pg_set_error_verbosity(3) [php man page]

PG_SET_ERROR_VERBOSITY(3)												 PG_SET_ERROR_VERBOSITY(3)

pg_set_error_verbosity - Determines the verbosity of messages returned bypg_last_error(3)andpg_result_error(3).

SYNOPSIS

       int pg_set_error_verbosity ([resource  $connection], int  $verbosity)

DESCRIPTION

	Determines the verbosity of messages returned by pg_last_error(3) and pg_result_error(3).

       pg_set_error_verbosity(3)  sets	the verbosity mode, returning the connection's previous setting. In PGSQL_ERRORS_TERSE mode, returned mes-
       sages include severity, primary text, and position only; this will normally fit on a single line. The default mode (  PGSQL_ERRORS_DEFAULT)
       produces messages that include the above plus any detail, hint, or context fields (these may span multiple lines). The PGSQL_ERRORS_VERBOSE
       mode includes all available fields. Changing the verbosity does not affect the messages available  from	already-existing  result  objects,
       only subsequently-created ones.

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).

	      o $verbosity
		- The required verbosity: PGSQL_ERRORS_TERSE, PGSQL_ERRORS_DEFAULT or PGSQL_ERRORS_VERBOSE.

RETURN VALUES

	The previous verbosity level: PGSQL_ERRORS_TERSE, PGSQL_ERRORS_DEFAULT or PGSQL_ERRORS_VERBOSE.

EXAMPLES

       Example #1

	      pg_set_error_verbosity(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		if (!pg_connection_busy($dbconn)) {
		    pg_send_query($dbconn, "select * from doesnotexist;");
		}

		pg_set_error_verbosity($dbconn, PGSQL_ERRORS_VERBOSE);
		$res1 = pg_get_result($dbconn);
		echo pg_result_error($res1);
	      ?>

SEE ALSO

       pg_last_error(3), pg_result_error(3).

PHP Documentation Group 												 PG_SET_ERROR_VERBOSITY(3)

PG_SEND_QUERY(3)														  PG_SEND_QUERY(3)

pg_send_query - Sends asynchronous query

SYNOPSIS

       bool pg_send_query (resource  $connection, string  $query)

DESCRIPTION

       pg_send_query(3)  sends	a  query or queries asynchronously to the $connection. Unlike pg_query(3), it can send multiple queries at once to
       PostgreSQL and get the results one by one using pg_get_result(3).

	Script execution is not blocked while the queries are executing. Use pg_connection_busy(3) to check if the connection is  busy	(i.e.  the
       query is executing). Queries may be cancelled using pg_cancel_query(3).

	Although  the user can send multiple queries at once, multiple queries cannot be sent over a busy connection. If a query is sent while the
       connection is busy, it waits until the last query is finished and discards all its results.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource.

	      o $query
		- The SQL statement or statements to be executed.  Data inside the query should be properly escaped.

RETURN VALUES

       Returns TRUE on success or FALSE on failure.

	Use pg_get_result(3) to determine the query result.

EXAMPLES

       Example #1

	      pg_send_query(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		if (!pg_connection_busy($dbconn)) {
		    pg_send_query($dbconn, "select * from authors; select count(*) from authors;");
		}

		$res1 = pg_get_result($dbconn);
		echo "First call to pg_get_result(): $res1
";
		$rows1 = pg_num_rows($res1);
		echo "$res1 has $rows1 records

";

		$res2 = pg_get_result($dbconn);
		echo "Second call to pg_get_result(): $res2
";
		$rows2 = pg_num_rows($res2);
		echo "$res2 has $rows2 records
";
	      ?>

	      The above example will output:

	      First call to pg_get_result(): Resource id #3
	      Resource id #3 has 3 records

	      Second call to pg_get_result(): Resource id #4
	      Resource id #4 has 1 records

SEE ALSO

       pg_query(3), pg_cancel_query(3), pg_get_result(3), pg_connection_busy(3).

PHP Documentation Group 													  PG_SEND_QUERY(3)