Pdo\Pgsql::setNoticeCallback
Set a callback to handle notice and warning messages generated by the backend
Description
public void Pdo\Pgsql::setNoticeCallback(callablenull $callback)
Set a callback to handle notice and warning messages generated by the backend.
This includes messages emitted by PostgreSQL itself,
as well as those raised by user-defined SQL functions using RAISE.
Please note that the actual receipt of these messages
depends on the backend setting client_min_messages.
Parameters
-
callback
-
If
null is passed, the handler is reset to its default state.
Otherwise, the handler is a callback with the following signature:
void handler(string $message)
-
message
-
A message generated by the backend.
Return Values
No value is returned.
Examples
Example #1 Pdo\Pgsql::setNoticeCallback example
<?php
$pdo = new Pdo\Pgsql('pgsql:dbname=test host=localhost', $user, $pass);
$pdo->exec('CREATE TABLE parent(id int primary key)');
$pdo->exec('CREATE TABLE child(id int references parent)');
$pdo->setNoticeCallback(function ($message) {
echo $message;
});
$pdo->exec('TRUNCATE parent CASCADE');
?>
The above example will output
something similar to:
NOTICE: truncate cascades to table "child"