Home > mailing lists

Re: How to watch for schema changes - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: How to watch for schema changes
Date	July 10, 2018 00:11:31
Msg-id	CAKFQuwaDE1omczs_Sd5aiGeqROiTR5JeCERZzbL6PZTWJnUcQw@mail.gmail.com Whole thread Raw
In response to	Re: How to watch for schema changes (Igor Korot <ikorot01@gmail.com>)
List	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.

From: Igor Korot
Date: 09 July 2018, 23:49:19
Subject: Re: How to watch for schema changes

From: Adrian Klaver
Date: 10 July 2018, 00:38:05
Subject: Re: How to watch for schema changes