trigger for pg_authid

Diego de Blas <diego.deblasm@gmail.com> schrieb:

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...

You can't create a TRIGGER on a system-table.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�

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.