Re: Is there a way to be notified on the CREATE TABLE execution?

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.

In response to

Responses

Browse pgsql-general by date

  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?