Re: elog in 7.4 - Mailing list pgsql-hackers

From Laszlo Hornyak
Subject Re: elog in 7.4
Date
Msg-id Pine.LNX.4.58.0409221453440.25952@www.forgeahead.hu
Whole thread Raw
In response to Re: elog in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: elog in 7.4  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: elog in 7.4  (Thomas Hallgren <thhal@mailblocks.com>)
List pgsql-hackers
Tom, is there other way in pg 7.4 than backporting PG_TRY? It seems a lot
of work.

Thanks,
Laszlo

On Tue, 21 Sep 2004, Tom Lane wrote:

> Laszlo Hornyak <kocka@forgeahead.hu> writes:
> > I am implementing a java language handler. If unrecoverable error occurs,
> > it needs to send a signal to the java process, so it can stop the
> > execution of the stored procedure, otherwise it would stay in inconsystent
> > state.
>
> Well, an elog callback is certainly the wrong place for that.  Even if
> it looked to see whether the elog call was ERROR or not, an ERROR is no
> longer necessarily unrecoverable --- it might be caught inside a plpgsql
> exception block, for example, and not really be an error at all from the
> perspective of calling code.
>
> The right way would be to use PG_TRY to catch the exception as it
> propagates out to your own level of control.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: todo: comment field for pg users and groups
Next
From: Alvaro Herrera
Date:
Subject: Re: todo: comment field for pg users and groups