PDO and PostgreSQL's LISTEN/NOTIFY

From: David J N Begley <d(dot)begley(at)uws(dot)edu(dot)au>
To: pgsql-php(at)postgresql(dot)org
Subject: PDO and PostgreSQL's LISTEN/NOTIFY
Date: 2006-10-04 01:25:19
Message-ID: Pine.LNX.4.61.0610041116180.964@viper.uws.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Is anyone aware of any effort currently underway to add support for
PostgreSQL's LISTEN/NOTIFY (async notification) feature to PDO?

At present the notification mechanism:

http://www.postgresql.org/docs/8.1/interactive/libpq-notify.html

is only available within PHP whilst using the old-style API:

http://www.php.net/manual/en/function.pg-get-notify.php

Unfortunately this means that applications ordinarily using PDO have to
include a mixture of old/new APIs (and separate connections/sessions) if they
want to receive notification messages. I was thinking of putting some time
into proposing an addition to the PDO_PGSQL driver:

http://www.php.net/manual/en/ref.pdo-pgsql.php

but didn't want to duplicate effort if someone has already written the code to
handle this feature.

Thanks..

Responses

Browse pgsql-php by date

  From Date Subject
Next Message ben wilko 2006-10-09 04:53:32 Tutorial/Example of Insert/Select PDF Postgres DB ?
Previous Message Robert Treat 2006-10-04 00:48:08 Re: Select Where using character varying ??