Re: How to handle error message in PG_CATCH

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

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

Thanks Zdenek