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.
begin:vcard
fn:Kenneth  Downs
n:Downs;Kenneth 
adr;dom:;;347 Main Street;East Setauket;NY;11733
email;internet:[EMAIL PROTECTED]
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
url:http://www.secdat.com
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to