From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | 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 15:20:34 |
Message-ID: | CA+FnnTy_=KNetdpxVn8APQw_3xpTxPq8nAe3FNdwD5-_KUBBpg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, David,
On Tue, Jun 19, 2018 at 5:13 PM, David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Tuesday, June 19, 2018, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>>
>> Hi, ALL,
>> Consider a scenario:
>>
>> 1. A software that uses libpq is executing.
>> 2. Someone opens up a terminal and creates a table.
>> 3. A software needs to know about this new table.
>
>
> I'd start here:
>
> 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.
I also looked at the
https://www.postgresql.org/docs/9.1/static/libpq-example.html#LIBPQ-EXAMPLE-2,
but am not sure how to create an appropriate event.
Thank you.
>
> David J.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Marks | 2018-06-20 15:40:53 | Re: tsvector field length limitation |
Previous Message | Tom Lane | 2018-06-20 14:49:04 | Re: tsvector field length limitation |