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)