Re: How to handle error message in PG_CATCH

Tom Lane napsal(a):
> Zdenek Kotala <Zdenek.Kotala@Sun.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.
> 

Thanks for explanation. I added extra error message at the end of 
function and it works now.

    Thanks Zdenek