Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support
Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Pavel Stehule 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