| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Is there a way to be notified on the CREATE TABLE execution? |
| Date: | 2018-06-20 16:44:40 |
| Message-ID: | CA+bJJbxGrvrmLr-Yx5mcAv9vcmXCcEmw1ZPRCc=Kv45AMu+qqQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jun 20, 2018 at 5:20 PM, Igor Korot <ikorot01(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2018-06-20 17:03:58 | Re: Is there a way to be notified on the CREATE TABLE execution? |
| Previous Message | Alban Hertroys | 2018-06-20 15:54:49 | Re: Is postorder tree traversal possible with recursive CTE's? |