| From: | "Atul Chojar" <achojar(at)airfacts(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | How to automatically propagate new/changed database functions from one database to another |
| Date: | 2009-06-05 17:12:15 |
| Message-ID: | 001201c9e600$c68dcca0$53a965e0$@com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
<http://www.airfacts.com/> AirFacts, Inc.
8120 Woodmont Ave., Suite 700
Bethesda, MD 20814
Tel: 301-760-7315
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2009-06-05 17:36:50 | Re: How to automatically propagate new/changed database functions from one database to another |
| Previous Message | Atul Chojar | 2009-06-05 17:11:46 | How to automatically propagate new/changed database functions from one database to another |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2009-06-05 17:17:44 | Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role |
| Previous Message | John R Pierce | 2009-06-05 17:07:13 | Re: postgresql source code is worth to read |