Edit report at https://bugs.php.net/bug.php?id=53818&edit=1
ID: 53818 Comment by: timosha at gmail dot com Reported by: r dot i dot k at free dot fr Summary: Missing info in pg_get_notify function Status: Assigned Type: Bug Package: PostgreSQL related Operating System: Linux PHP Version: 5.3.8 Assigned To: iliaa Block user comment: N Private report: N New Comment: hmm, seems that this patch applied for php-5.3.9 but no info in changelog Previous Comments: ------------------------------------------------------------------------ [2011-10-15 16:19:12] r dot i dot k at free dot fr The provided patch, 9 months ago, is still missing from 5.3 branch... It would be cool to have it pushed in official source code, since it still works (made for 5.2.17, applyable to 5.3.8), and give access to a feature appeared in PostgreSQL 14 months ago :((( ------------------------------------------------------------------------ [2011-10-14 06:06:49] timosha at gmail dot com Please backport this patch to 5.3.x. :) ------------------------------------------------------------------------ [2011-01-27 17:02:36] il...@php.net This bug has been fixed in SVN. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. ------------------------------------------------------------------------ [2011-01-22 19:32:25] r dot i dot k at free dot fr Description: ------------ Since Postgresql 9.0, event notifications fired by the NOTIFY sql command includes a payload (a 8000 bytes max piece of text). As of now, the PHP function pg_get_notify only retrieve the "channel" (name of the notification) and the backend pid. The attached patch improves this situation by adding the payload to the returned array of the pg_get_notify function, when the connected PG backend version is at least 9.0. Hope it helps... Test script: --------------- $dbconn = pg_connect(...) ; // To be completed pg_query($dbconn, "LISTEN toto"); pg_query($dbconn, "NOTIFY toto, 'Hello world !'"); $notify = pg_get_notify($dbconn, PGSQL_ASSOC) ; print_r($notify) ; Expected result: ---------------- // Array("message" => "toto", "pid" => 12345, "payload" => "Hello world !") Actual result: -------------- // Array("message" => "toto", "pid" => 12345) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=53818&edit=1
