Re: Is there a way to be notified on the CREATE TABLE execution? - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Is there a way to be notified on the CREATE TABLE execution?
Date
Msg-id CA+bJJbxGrvrmLr-Yx5mcAv9vcmXCcEmw1ZPRCc=Kv45AMu+qqQ@mail.gmail.com
Whole thread Raw
In response to Re: Is there a way to be notified on the CREATE TABLE execution?  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Is there a way to be notified on the CREATE TABLE execution?  (Melvin Davidson <melvin6925@gmail.com>)
Re: Is there a way to be notified on the CREATE TABLE execution?  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
On Wed, Jun 20, 2018 at 5:20 PM, Igor Korot <ikorot01@gmail.com> wrote:
>>  https://www.postgresql.org/docs/10/static/sql-createeventtrigger.html
>> Your scenario suggests you may wish to avail yourself of the Listen and
>> Notify commands as well.
>
> I did look at the Listen/Notify.
> Unfortunately the listening is done on the channel versus listening
> for the specific event.

Channels are cheap. You just listen on "whatever" and in the event
trigger you notify "whatever", payload is optional.

The event trigger is the one which takes care of filtering the event
and notifying selectively.

You can use a channel per event.

Francisco Olarte.


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Is postorder tree traversal possible with recursive CTE's?
Next
From: Melvin Davidson
Date:
Subject: Re: Is there a way to be notified on the CREATE TABLE execution?