Re: User's exception plpgsql

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: User's exception plpgsql
Дата
Msg-id 42E5C41E.1060805@samurai.com
обсуждение исходный текст
Ответ на Re: User's exception plpgsql  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Ответы Re: User's exception plpgsql
Список pgsql-patches
Pavel Stehule wrote:
> can you show sample, please?

modifying_sql_data_not_permitted, null_value_not_allowed,
prohibited_sql_statement_attempted and reading_sql_data_not_permitted
are the examples I can see from scanning plerrcodes.h. If we had this to
do over again, I'm not sure I see the point in mapping a single
condition names to multiple SQLSTATEs, but it's probably too late to
undo that now.

> 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

Yeah, that's possible, but it doesn't seem any nicer :-(

-Neil

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] Autovacuum loose ends
Следующее
От: Tom Lane
Дата:
Сообщение: Re: User's exception plpgsql