PDO and PostgreSQL's LISTEN/NOTIFY
| From: | David J N Begley | Date: | Wed, 04 Oct 2006 01:26:23 +0000 |
| Subject: | PDO and PostgreSQL's LISTEN/NOTIFY | ||
| Groups: | php.pecl.dev | ||
| Request: | Send a blank email to pecl-dev+get-4209@lists.php.net to get a copy of this message | ||
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..