PG_LAST_ERROR(3) PG_LAST_ERROR(3)
pg_last_error - Get the last error message string of a connection
SYNOPSIS
string pg_last_error ([resource $connection])
DESCRIPTION
pg_last_error(3) returns the last error message for a given $connection.
Error messages may be overwritten by internal PostgreSQL (libpq) function calls. It may not return an appropriate error message if multi-
ple errors occur inside a PostgreSQL module function.
Use pg_result_error(3), pg_result_error_field(3), pg_result_status(3) and pg_connection_status(3) for better error handling.
Note
This function used to be called pg_errormessage(3).
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
RETURN VALUES
A string containing the last error message on the given $connection, or FALSE on error.
EXAMPLES
Example #1
pg_last_error(3) example
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
// Query that fails
$res = pg_query($dbconn, "select * from doesnotexist");
echo pg_last_error($dbconn);
?>
SEE ALSO
pg_result_error(3), pg_result_error_field(3).
PHP Documentation Group PG_LAST_ERROR(3)