Re: How to watch for schema changes

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to watch for schema changes
Дата
Msg-id CAKFQuwaDE1omczs_Sd5aiGeqROiTR5JeCERZzbL6PZTWJnUcQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to watch for schema changes  (Igor Korot <ikorot01@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Jul 9, 2018 at 1:49 PM, Igor Korot <ikorot01@gmail.com> wrote:
Just a thought...
Is it possible to create a trigger for a system table?
Not sure, and doesn't seem documented either way, but seems easy enough to try on a test cluster...
​[...]​
 
Successful "CREATE TABLE..." statement creates a row inside the
information_schema.tables

​Given that information_schema.tables is a view, not a table, it doesn't make a valid hook point for the trigger regardless of the previous point.

David J.

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

Предыдущее
От: Igor Korot
Дата:
Сообщение: Re: How to watch for schema changes
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to watch for schema changes