Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support (Really Oracle behavior)

Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> What it is mean?

I think it means Oracle is broken ;-)

> So we can have only one procedure level scope variable, which is
> initialized on start of exception and zeroized on the end of exception
> block. This behavior is different from my patch, but is better for Oracle
> compatibility and I prefere its.

That might be taking the notion of bug-compatibility with PL/SQL
a bit too far.  For that matter, did you check whether Oracle
actually treats it as a procedure-scope variable?  Try having the
exception block call another function and trap an error inside that.
Does SQLCODE change in the calling function?

            regards, tom lane