Re: sync the data's from catalog table

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Dinesh kumar <shenid(dot)08(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: sync the data's from catalog table
Date: 2017-11-13 08:42:59
Message-ID: 1510562579.2835.2.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bo Thorbjørn Jensen 2017-11-13 09:45:56 missing public on schema public
Previous Message Andreas Joseph Krogh 2017-11-13 08:27:33 PG-10 + ICU and abbreviated keys