Which error constant to use for "permission deny error when updating a table that user is not allowd to "

Поиск
Список
Период
Сортировка
От Emi Lu
Тема Which error constant to use for "permission deny error when updating a table that user is not allowd to "
Дата
Msg-id 443162FD.4040408@encs.concordia.ca
обсуждение исходный текст
Ответы Re: Which error constant to use for "permission deny error when updating a table that user is not allowd to "  ("William Leite Araújo" <william.bh@gmail.com>)
Список pgsql-general
Hello,

I am trying to catch permission denied exception. For example, user 1 is
not allowed to update table 2, when user1 updated table 2 there is a
permission excetpion.

In http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html,
I tried "modifying_sql_data_not_permitted" , "sql_routine_exception",
"external_routine_exception" but none of them catch the permission deny
error.

Could someone tell me which error constant should I use to catch the
permission denied error please?

Thanks a lot!
Ying


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

Предыдущее
От: Kai Hessing
Дата:
Сообщение: Re: Performance Killer 'IN' ?
Следующее
От: "William Leite Araújo"
Дата:
Сообщение: Re: Which error constant to use for "permission deny error when updating a table that user is not allowd to "