event trigger should provide more details - Mailing list pgsql-general

From Lian Jiang
Subject event trigger should provide more details
Date
Msg-id CA+aY8X7=FZmg0V-+5HN+FBRJRgZ4j0TFqknJucetd3uaGnKJMA@mail.gmail.com
Whole thread Raw
Responses Re: event trigger should provide more details
List pgsql-general


hi,

I plan to create an event trigger to detect schema change (e.g. add/remove a column, change column type), and write it into a separate table (e.g. EVENTS). Then a process periodically reads this table to send schema change notification. However, the event trigger (43.10.2. Triggers on Events) does not provide me info such as which table is altered, old and new schema. Am I missing something? Thanks very much for any hints.

Regards
Lian

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: Re: syntax pb
Next
From: Ron
Date:
Subject: Pg 16: will pg_dump & pg_restore be faster?