| 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: | Whole Thread | Raw Message | 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? |