How to automatically propagate new/changed database functions from one database to another

Поиск
Список
Период
Сортировка
От Atul Chojar
Тема How to automatically propagate new/changed database functions from one database to another
Дата
Msg-id 001201c9e600$c68dcca0$53a965e0$@com
обсуждение исходный текст
Ответы Re: How to automatically propagate new/changed database functions from one database to another  ("Joshua D. Drake" <jd@commandprompt.com>)
Different handling of PL/pgSQL for-loop variables in 8.3.7 vs. 8.2.7 ???  ("Atul Chojar" <achojar@airfacts.com>)
Список 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

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

 

 

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: postgresql source code is worth to read
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role