Re: Question on notifications

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Question on notifications
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C207CD330E@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Question on notifications  (Alexander Reichstadt <info@apfeltaste.net>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Reichstadt
Дата:
Сообщение: Re: Question on notifications
Следующее
От: Alexander Reichstadt
Дата:
Сообщение: Listen and Notify