Re: How to handle error message in PG_CATCH

Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> writes:
> Alvaro Herrera napsal(a):
>> Zdenek Kotala wrote:
>>> At the end I got following message:
>>>
>>> ERROR: Error test
>>> CONTEXT: Context error
>>> server sent data ("D" message) without prior row description ("T" message)
>>
>> I don't see anything wrong with this code. Perhaps the problem is
>> somewhere else?

> There is whole test code. It is store procedure and there are nothing
> special. The difference between this and autovacuum is that autovacuum
> works without client side.

The problem with this is it's violating the wire protocol. Once you've
sent the client an ERROR message, it no longer expects to see any result
from the SELECT that called the function.

regards, tom lane