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

From Igor Korot
Subject Re: Is there a way to be notified on the CREATE TABLE execution?
Date
Msg-id CA+FnnTyr4yemSa8UfnuYgbFCHeL+nx5bc2yrEy+JvX3jtQnp4Q@mail.gmail.com
Whole thread Raw
In response to Re: Is there a way to be notified on the CREATE TABLE execution?  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: Is there a way to be notified on the CREATE TABLE execution?  (Francisco Olarte <folarte@peoplecall.com>)
List 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@peoplecall.com> wrote:
> 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: Melvin Davidson
Date:
Subject: Re: Is there a way to be notified on the CREATE TABLE execution?
Next
From: Francisco Olarte
Date:
Subject: Re: Is there a way to be notified on the CREATE TABLE execution?