Re: patch for pg_autovacuum 8.0.x prevent segv for dropped

Tom Lane wrote:

>daveg <daveg@sonic.net> writes:
>
>
>>Below is a patch for this that should apply against any 8.0.x. The change
>>verifies that the catalog query returned some rows before accessing the row
>>data.
>>
>>
>
>Surely this is completely broken?  AFAICT you are testing the result
>from a VACUUM or ANALYZE command, which is not going to return any
>tuples.
>
>

I guess he should change

    if (PQntuples(res))

to

    if (|PQresultStatus|(res) == PGRES_COMMAND_OK)

?

cheers

andrew