Re: trigger for pg_authid

Поиск
Список
Период
Сортировка
От Kenneth Downs
Тема Re: trigger for pg_authid
Дата
Msg-id 45CC8C15.6050406@secdat.com
обсуждение исходный текст
Ответ на trigger for pg_authid  ("Diego de Blas" <diego.deblasm@gmail.com>)
Список pgsql-general
Diego de Blas wrote:
> Hello,
>
> I'm trying to set a new trigger for "pg_authid" connected as
> "postgres" but system returns always the same error "Permission
> denied: "pg_authid" is a system catalog"... I have checked privileges
> and I can teorically add new triggers. I don't know whta's wrong...
>
> Thanks

We went the other way with this.  We created our own table of users, and
put a trigger on that so that INSERTS to that table created new users in
postgres, plus anything else we needed to happen.  We did the same with
a table of user-group membership.

Вложения

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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: intarray index vs gin index
Следующее
От: johnf
Дата:
Сообщение: Re: does anyone have a tool to convert SP'sT-SQL to Postgres