pg_last_notice

Description

string pg_last_notice ( resource connection)

pg_last_notice() returns the last notice message from the PostgreSQL server specified by connection_ The PostgreSQL server sends notice messages in several cases, e_g_ if the transactions can't be continued_ With pg_last_notice(), you can avoid issuing useless queries, by checking whether the notice is related to the transaction or not_

Aviso

This function is EXPERIMENTAL and it is not fully implemented yet_ pg_last_notice() was added in PHP 4_0_6_ However, PHP 4_0_6 has problem with notice message handling_ Use of the PostgreSQL module with PHP 4_0_6 is not recommended even if you are not using pg_last_notice()_

This function is fully implemented in PHP 4_3_0_ PHP earlier than PHP 4_3_0 ignores database connection parameter_

Notice message tracking can be set to optional by setting 1 for pgsql_ignore_notice in php_ini from PHP 4_3_0_

Notice message logging can be set to optional by setting 0 for pgsql_log_notice in php_ini from PHP 4_3_0_ Unless pgsql_ignore_notice is set to 0, notice message cannot be logged_

See also pg_query() and pg_last_error()_