listen/notify using C# and Npgsql

From: Pascal Cloup <ptpas059(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: listen/notify using C# and Npgsql
Date: 2015-04-17 18:48:59
Message-ID: CA+ubD0jfZdnaN68ZewyhtdqCYj-R4YZwroOxdFWQOdGgX4NN7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Nirban Sen 2015-04-21 05:32:46 How to disable auto-commit in postgresql-9.4
Previous Message Michael Wood 2015-04-11 21:23:16 Re: psql overwrites command line