Re: Question on notifications - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Question on notifications
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207CD330E@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Question on notifications  (Alexander Reichstadt <info@apfeltaste.net>)
List pgsql-general
Alexander Reichstadt wrote:
> From the documentation I was able to build a trigger firing upon
deletion of a record a function that
> delivers tablename_operation as a notification one needs to subscribe
to. So in terminal I can say
> LISTEN persons_delete and instantly will receive
>
>     Asynchronous notification "persons_delete" received from server
process with PID 54790.
>
> if there was a delete. But what I don't fully understand is how to do
this with PQnotifies. Following
> the docu I get no notifications even though I subscribe to them after
successfully connecting to the
> server the same way I do using terminal.
>
> Googling didn't give me examples I was able to use. Please, can
someone help?

Did you look at the example in the documentation?
http://www.postgresql.org/docs/current/static/libpq-example.html#LIBPQ-E
XAMPLE-2

Can you post relevant parts of your code?

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Alexander Reichstadt
Date:
Subject: Re: Question on notifications
Next
From: Alexander Reichstadt
Date:
Subject: Listen and Notify