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

Поиск
Список
Период
Сортировка
От Igor Korot
Тема Re: Is there a way to be notified on the CREATE TABLE execution?
Дата
Msg-id CA+FnnTyr4yemSa8UfnuYgbFCHeL+nx5bc2yrEy+JvX3jtQnp4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is there a way to be notified on the CREATE TABLE execution?  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: Is there a way to be notified on the CREATE TABLE execution?
Список 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 по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Is there a way to be notified on the CREATE TABLE execution?
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: Is there a way to be notified on the CREATE TABLE execution?