Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] sync the data's from catalog table - Mailing list pgsql-general

From Dinesh kumar
Subject Re: [GENERAL] sync the data's from catalog table
Date
Msg-id CAM5WAJMb2PHy0y78y8uWs29LRL0v1GwtbveDtWyTrXO1GkFv5A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] sync the data's from catalog table  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Bo Thorbjørn Jensen
Date:
Subject: [GENERAL] missing public on schema public
Next
From: Mark Morgan Lloyd
Date:
Subject: Re: [GENERAL] pg on Debian servers