Thread: [GENERAL] sync the data's from catalog table
Hi Team,
How can I sync the data's from pg_authid to manually created table (user table) whenever the update or insert happens on pg_authid table.
Thanks
Dinesh Kumar
Dinesh kumar wrote: > How can I sync the data's from pg_authid to manually created table (user table) whenever the update or insert happens onpg_authid table. You cannot do this, because you cannot define triggers on catalog tables. The question is: Why do you want to do this? What are you trying to achieve? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Hi,
Whenever the postgres user is trying to modify the user account's password column in pg_authid table, we need to maintain a trigger in catalog table (pg_authid) where it pop up the the "password column has been restricted and it should not be modified". Is there any possible for the above scenario in postgres? if it there please guide me how to proceed on this.
and one more question, Can we restrict the postgres user to not modify the pg_authid table. Please share your thoughts on it.
Thanks
On Mon, Nov 13, 2017 at 2:12 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
Dinesh kumar wrote:
> How can I sync the data's from pg_authid to manually created table (user table) whenever the update or insert happens on pg_authid table.
You cannot do this, because you cannot define triggers on catalog tables.
The question is:
Why do you want to do this? What are you trying to achieve?
Yours,
Laurenz Albe