Re: User's exception plpgsql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: User's exception plpgsql
Дата
Msg-id Pine.LNX.4.44.0507260637070.18191-100000@kix.fsv.cvut.cz
обсуждение исходный текст
Ответ на Re: User's exception plpgsql  (Neil Conway <neilc@samurai.com>)
Ответы Re: User's exception plpgsql
Список pgsql-patches
On Tue, 26 Jul 2005, Neil Conway wrote:

> Neil Conway wrote:
> > Not at the moment. I believe we have agreed that it would be better to
> > remove the concept of "exception variables" and just use strings, but I
> > haven't implemented this yet.
>
> BTW, one minor annoyance I noticed: a builtin condition name can
> actually map to multiple SQLSTATE values.

can you show sample, please?

If we allow a builtin
> condition name to be specified to RAISE, this means we'll actually need
> to pass around a list of SQLSTATE values that are thrown by the RAISE,
> rather than a single SQLSTATE. This seems pretty ugly, though --
> especially considering that only a handful of the builtin condition
> names actually do map to multiple SQLSTATEs. Does anyone have a better
> suggestion?
>

Exception variables can solve it, but its dead concept. We can have list
of prohibited condition names and for its throw compile error

condition name is ambigous

Pavel

> -Neil
>


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Regression - GNUmakefile - pg_usleep
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: User's exception plpgsql