Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support which sets these values

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support which sets these values
Дата
Msg-id 200505270030.41028.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support which sets these values  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Does Oracle support GET DIAGNOSTICS?  If so, couldn't we just use
> > that? I can't see what good will become of making any slightly
> > useful information become available as magic variables of some
> > kind.
>
> Oracle actually defines these things as parameterless functions that
> are called without parentheses (like CURRENT_USER).  "Magic
> variables" are about as close as we can get to matching that.

What I was aiming for is this: If Oracle supported GET DIAGNOSTICS, then
we could ask people to switch to that instead of using the magic
variables and they'd still have code that works both ways.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

В списке pgsql-committers по дате отправления:

Предыдущее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Document that utility commands such as DROP FUNCTION allow
Следующее
От: andrewd@pgfoundry.org (User Andrewd)
Дата:
Сообщение: pgbuildfarm - client-code: experimantal code to enable vpath builds -