Re: Using LISTEN/NOTIFY in C#.NET - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Using LISTEN/NOTIFY in C#.NET
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7AE4@algol.sollentuna.se
Whole thread Raw
In response to Using LISTEN/NOTIFY in C#.NET  (Josephine de Castro <jedecastro23@yahoo.com>)
List pgsql-general
> > To make the long story short...my question is this..is it
> possible to
> > run the listener command in C# or will it only work in psql?
>
> There's no theoretical reason why not.  You probably need to
> read the docs on whatever C# Postgres driver you're using
> (ADO, ODBC etc) and find out how it handles LISTEN/NOTIFY, as
> that's not (AFAIK) a standard feature.

IIRC, you need to use the NPgsql native driver to do it. It doesn't work
through ODBC or such - at least not the way you want it.


//Magnus

pgsql-general by date:

Previous
From: Alex Turner
Date:
Subject: Re: On "multi-master"
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL Gotchas