listen/notify using C# and Npgsql

Поиск
Список
Период
Сортировка
От Pascal Cloup
Тема listen/notify using C# and Npgsql
Дата
Msg-id CA+ubD0jfZdnaN68ZewyhtdqCYj-R4YZwroOxdFWQOdGgX4NN7A@mail.gmail.com
обсуждение исходный текст
Список pgsql-novice
Hi,

I'm new to Postgresql. To try and learn and evaluate postgresql, i made an application using Npgsql adapter for ADO.net and C#. All works fine, but now i would like to obtain the following functionality:

when a app modifies a part of a DB, i want that another instance of my app (running on another pc) is informed automatically.
I saw that Postgresql owns a Listen/Notify mechanism, and Triggers and that Npgsql implements this thru
NotificationEventHandler,. Currently this works inside the same instance of the app, but not on the remote pc.

Someone can help or gives a link to a sample?

thanks in advance

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Wood
Дата:
Сообщение: Re: psql overwrites command line
Следующее
От: Nirban Sen
Дата:
Сообщение: How to disable auto-commit in postgresql-9.4