Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

#1 (**permalink**) 04-10-2008, 12:04 PM

Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> On Thu, 2 Jun 2005, Tom Lane wrote:
>> The results of Pavel's experiments prove that Oracle's behavior is
>> pretty random --- it looks to me like the chance results of whatever

> What I can speek. Oracle has session variable for saving err code of last
> exception. On the start of session is zero. After executing any EXCEPTION
> BLOCK is this session zeroed. I can't to see so it's buggy behavior.

Well, it may not be strictly a "bug", but it's certainly a very poor
design, since it fails to cope at all nicely with nested-exception cases.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode