Re: trigger for pg_authid - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: trigger for pg_authid
Date
Msg-id 20070209144711.GA16712@KanotixBox
Whole thread Raw
In response to trigger for pg_authid  ("Diego de Blas" <diego.deblasm@gmail.com>)
List pgsql-general
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°

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Possibly odd question; diff results?
Next
From: Teodor Sigaev
Date:
Subject: Re: intarray index vs gin index