Re: [GENERAL] sync the data's from catalog table

2017-11-13 Thread Dinesh kumar
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

Re: [GENERAL] sync the data's from catalog table

2017-11-13 Thread Laurenz Albe
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

[GENERAL] sync the data's from catalog table

2017-11-12 Thread Dinesh kumar
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