Postgres Pro
Downloads
Home   >   mailing lists

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

From Joshua D. Drake
Subject Re: How to automatically propagate new/changed database functions from one database to another
Date
Msg-id 1244223410.12929.27.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to How to automatically propagate new/changed database functions from one database to another  ("Atul Chojar" <achojar@airfacts.com>)
Responses Re: How to automatically propagate new/changed database functions from one database to another
List pgsql-general
Tree view 
On Fri, 2009-06-05 at 13:12 -0400, Atul Chojar wrote:
> 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?


This is the wrong away to go about it. You should put this into your
development process not within the database itself. There are a number
of utilities that would allow you to do such a thing.

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997

pgsql-general by date:

Previous
From: "Louis Lam"
Date:
Subject: Re: catalog view use to find DATABASE, LANGUAGE,TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role
Next
From: Andy Colson
Date:
Subject: Re: maintaining referential integrity