pg_result_error_field
You can use pg_set_error_verbosity() to retrieve SQLSTATUS from pg_last_error().
pg_result_error
(PHP 4 >= 4.2.0, PHP 5)
pg_result_error — Restituisce i messaggio di errore associato al risultato
Descrizione
string pg_result_error
( resource $risultato
)
pg_result_error() restituisce il messaggio di errore associato alla risorsa risultato . Quindi, l'utente ha la possibilità di ottenere un messaggio più preciso rispetto alla pg_last_error().
vedere anche pg_query(), pg_send_query(), pg_get_result(), pg_last_error() e pg_last_notice()
add a note
User Contributed Notespg_result_error
axon dot wp at wp dot pl
02-Mar-2006 04:20
02-Mar-2006 04:20
15-Mar-2004 04:12
Because pg_query() returns FALSE if the query fails, you must must use pg_send_query() and pg_get_result() to get the result handle.
PostgreSQL 7.4 introduced a new function called PQresultErrorField() that can be used to get SQLSTATE code from a query, which is far more useful than the error string returned from pg_result_error().
http://www.postgresql.org/docs/7.4/static/libpq-exec.html
http://www.postgresql.org/docs/7.4/static/errcodes-appendix.html
Here's a patch that adds the pg_result_error_field() function to PHP:
http://collapsed.net/patches/php-4.3.5RC3-pg_result_error_field.diff
(To apply the patch cd into your php-4.3.5RC directory and type: patch -p1 </path/to/php-4.3.5RC3-pg_result_error_field.diff)
Example code:
<?php
if(!($db = pg_connect("user=foo password=bar dbname=foobar")))
die("pg_connect");
if(!pg_send_query($db, "SELECT foo FROM bar"))
die("pg_send_query");
if(!($result = pg_get_result($db)))
die("pg_get_result");
echo(pg_result_error($result) . "<br />\n");
/* only available if you have patched php */
if(function_exists("pg_result_error_field"))
{
$fieldcode = array(
"PGSQL_DIAG_SEVERITY", "PGSQL_DIAG_SQLSTATE",
"PGSQL_DIAG_MESSAGE_PRIMARY", "PGSQL_DIAG_MESSAGE_DETAIL",
"PGSQL_DIAG_MESSAGE_HINT", "PGSQL_DIAG_STATEMENT_POSITION",
"PGSQL_DIAG_CONTEXT", "PGSQL_DIAG_SOURCE_FILE",
"PGSQL_DIAG_SOURCE_LINE", "PGSQL_DIAG_SOURCE_FUNCTION");
foreach($fieldcode as $fcode)
{
printf("%s: %s<br />\n",
$fcode,
pg_result_error_field($result, constant($fcode)));
}
pg_free_result($result);
}
?>
<?php pg_result_error_field($result, PGSQL_DIAG_SQLSTATE); ?>
Returns the SQLSTATE code.