From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | Francisco Olarte <folarte(at)peoplecall(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 17:07:13 |
Message-ID: | CA+FnnTyr4yemSa8UfnuYgbFCHeL+nx5bc2yrEy+JvX3jtQnp4Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thx, Francisco.
It makes sense now.
Just one more question:
This page https://www.postgresql.org/docs/current/static/xfunc-c.html#DFUNC
does not reference
Windows/MSVC/MinGW as a way to compile the code.
How should I do it?
Thx.
On Wed, Jun 20, 2018 at 11:44 AM, Francisco Olarte
<folarte(at)peoplecall(dot)com> wrote:
> 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 | Francisco Olarte | 2018-06-20 17:22:22 | Re: Is there a way to be notified on the CREATE TABLE execution? |
Previous Message | Melvin Davidson | 2018-06-20 17:03:58 | Re: Is there a way to be notified on the CREATE TABLE execution? |