PHP kézikönyv
Előző |  | Következő

# pg_last_notice

(PHP 4 >= 4.0.6, PHP 5)

pg_last_notice -- Returns the last notice message from PostgreSQL server

## Leírás

string pg_last_notice ( resource connection )

pg_last_notice() returns the last notice message from the PostgreSQL server on the specified connection. The PostgreSQL server sends notice messages in several cases, for instance when creating a SERIAL column in a table.

With pg_last_notice(), you can avoid issuing useless queries by checking whether or not the notice is related to your transaction.

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

## Paraméterek

connection

  PostgreSQL database connection resource.

## Visszatérési értékek

A string containing the last notice on the given connection, or `FALSE` on error.

## Példák

Példa 1. pg_last_error() example

`<?php $pgsql_conn = pg_connect("dbname=mark host=localhost"); $res = pg_query("CREATE TABLE test (id SERIAL)"); $notice = pg_last_notice($pgsql_conn); echo $notice; ?>`

A fenti példa a következő kimenetet adja:

    CREATE TABLE will create implicit sequence "test_id_seq" for "serial" column "test.id"

## Lásd még

pg_query()
pg_last_error()

Előző | Tartalom | Következő
pg_last_error | Fel | pg_last_oid