Обсуждение: Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

Поиск
Список
Период
Сортировка

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

От
Tom Lane
Дата:
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