Postgres Pro
Downloads
Home   >   mailing lists

How to automatically propagate new/changed database functions from one database to another - Mailing list pgsql-general

From Atul Chojar
Subject How to automatically propagate new/changed database functions from one database to another
Date
Msg-id 001201c9e600$c68dcca0$53a965e0$@com
Whole thread Raw
Responses Re: How to automatically propagate new/changed database functions from one database to another
Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???
List pgsql-general
Tree view

We want to implement a mechanism by which if any database function is created or modified in one database, then the same should automatically get done in another (1 or more) database(s).

 

It seems triggers on system catalogs like pg_proc are not allowed. Is there any way in postgres to do this, by some other way?

 

Thanks!

atul

AirFacts, Inc. 8120 Woodmont Ave., Suite 700 Bethesda, MD 20814 Tel: 301-760-7315

 

 

Attachment

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: postgresql source code is worth to read
Next
From: Martijn van Oosterhout
Date:
Subject: Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role