Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support
Date
Msg-id 13986.1117724516@sss.pgh.pa.us
Whole thread Raw
List pgsql-committers
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

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: The no-lexer-backup speedup hadn't been there a week before