Skip site navigation (1) Skip section navigation (2)

[PATCH] notify support for DBD::Pg

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: e(dot)mergl(at)bawue(dot)de
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: [PATCH] notify support for DBD::Pg
Date: 2001-06-10 19:59:45
Message-ID: Pine.BSO.4.10.10106101552000.23782-200000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Edmund & all,

Attached is a patch to add support for asynchronous notifications to
DBD::Pg interface. 

Added following functions (self-documented in Pg.pm):

  $ret = $dbh->func('notifies');

Returns either undef or a reference to two-element array
[ $table, $backend_pid ] of asynchronous notifications received.

  $fd = $dbh->func('getfd');

Returns fd of the actual connection to server. Can be used with
select() and func('notifies').

Also modified test.pl to test all of this functionality in the following
sequence (listen, select, notify, select).

Edmund, please consider adding to next release.

Thanks

-alex

Attachment: dbdpg.patch
Description: text/plain (4.9 KB)

pgsql-interfaces by date

Next:From: Andrea AimeDate: 2001-06-11 06:52:34
Subject: Re: [INTERFACES] The future of pgAdmin...
Previous:From: Bruce MomjianDate: 2001-06-10 02:55:46
Subject: Re: libpq sockets on win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group