Re: Using LISTEN/NOTIFY in C#.NET

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Douglas McNaught" <doug(at)mcnaught(dot)org>, "Josephine de Castro" <jedecastro23(at)yahoo(dot)com>
Cc: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using LISTEN/NOTIFY in C#.NET
Date: 2005-10-14 13:49:40
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C7AE4@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Alex Turner 2005-10-14 13:49:45 Re: On "multi-master"
Previous Message Devrim GUNDUZ 2005-10-14 13:26:45 New sets of PostgreSQL RPMS are available for download : 7.3.10, 8.0.4, 8.1beta3