[PHP-NOTES] note 130608 added to pdo-pgsql.getnotify

This page needs an example to understand that you **need** to explicitly call LISTEN before using getNotify, like shown in https://www.php.net/manual/en/function.pg-get-notify.php

<?php

$db = new PDO($dsn, $user, $password, $options);
$db->query('LISTEN test');
$notification = $db->pgsqlGetNotify(PDO::FETCH_ASSOC, 10000);

// or

$db = new Pdo\Pgsql($dsn, $user, $password, $options);
$db->query('LISTEN test');
$notification = $db->getNotify(PDO::FETCH_ASSOC, 10000);

// now you can call NOTIFY elsewhere
// PG> NOTIFY test, 'payload string';
var_dump($notification);

?>

array(3) {
  ["message"]=>
  string(4) "test"
  ["pid"]=>
  int(123565)
  ["payload"]=>
  string(14) "payload string"
}

If you called NOTIFY before calling LISTEN, nothing will be returned!

You receive the first notification only, and you have to call getNotify again. And call LISTEN again if DB connection drops.
----
Server IP: 206.189.2.9
Probable Submitter: 2a01:c846:3901:e400:35aa:d235:8839:f46f
----
Manual Page -- https://php.net/manual/en/pdo-pgsql.getnotify.php
Edit        -- https://main.php.net/note/edit/130608
Del: integrated  -- https://main.php.net/note/delete/130608/integrated
Del: useless     -- https://main.php.net/note/delete/130608/useless
Del: bad code    -- https://main.php.net/note/delete/130608/bad+code
Del: spam        -- https://main.php.net/note/delete/130608/spam
Del: non-english -- https://main.php.net/note/delete/130608/non-english
Del: in docs     -- https://main.php.net/note/delete/130608/in+docs
Del: other reasons-- https://main.php.net/note/delete/130608
Reject      -- https://main.php.net/note/reject/130608
Search      -- https://main.php.net/manage/user-notes.php