[PATCH] pg_result_error_field View as Markdown

In many situations one needs to know what caused the error
And probably receive additional information about it
(e.g which foreign key constraint failed).

I attach tiny patches giving access to
PQresultErrorField function.

Error messages may need adjustment.

Tested on PHP 5.0.2

Example of usage: (from DB class)

pg_send_query($this->link, 'INSERT INTO b VALUES(5)');
$res = pg_get_result($this->link);
echo pg_result_error_field($res, PGSQL_DIAG_MESSAGE_DETAIL));

Patches (see attach):

--- ../../../../../../lang/php5/work/php-5.0.2/ext/pgsql/pgsql.c Wed
May 12 16:49:47 2004
+++ pgsql.c Sat Nov 13 19:51:05 2004
@@ -124,6 +124,7 @@
PHP_FE(pg_get_pid, NULL)
/* error message functions */
PHP_FE(pg_result_error, NULL)

• PHP_FE(pg_result_error_field, NULL)
  PHP_FE(pg_last_error, NULL)
  PHP_FE(pg_last_notice, NULL)
  /* copy functions */
  @@ -438,6 +439,19 @@
  REGISTER_LONG_CONSTANT("PGSQL_SEEK_SET", SEEK_SET, CONST_CS |
  CONST_PERSISTENT);
  REGISTER_LONG_CONSTANT("PGSQL_SEEK_CUR", SEEK_CUR, CONST_CS |
  CONST_PERSISTENT);
  REGISTER_LONG_CONSTANT("PGSQL_SEEK_END", SEEK_END, CONST_CS |
  CONST_PERSISTENT);
• /* For pg_result_error_field() */
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_SEVERITY", PG_DIAG_SEVERITY,
  CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_SQLSTATE", PG_DIAG_SQLSTATE,
  CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_MESSAGE_PRIMARY",
  PG_DIAG_MESSAGE_PRIMARY, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_MESSAGE_DETAIL",
  PG_DIAG_MESSAGE_DETAIL, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_MESSAGE_HINT",
  PG_DIAG_MESSAGE_HINT, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_STATEMENT_POSITION",
  PG_DIAG_STATEMENT_POSITION, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_INTERNAL_POSITION",
  PG_DIAG_INTERNAL_POSITION, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_INTERNAL_QUERY",
  PG_DIAG_INTERNAL_QUERY, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_CONTEXT", PG_DIAG_CONTEXT,
  CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_SOURCE_FILE",
  PG_DIAG_SOURCE_FILE, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_SOURCE_LINE",
  PG_DIAG_SOURCE_LINE, CONST_CS | CONST_PERSISTENT);
• REGISTER_LONG_CONSTANT("PGSQL_DIAG_SOURCE_FUNCTION",
  PG_DIAG_SOURCE_FUNCTION, CONST_CS | CONST_PERSISTENT);
  /* For pg_result_status() return value type /
  REGISTER_LONG_CONSTANT("PGSQL_STATUS_LONG", PGSQL_STATUS_LONG,
  CONST_CS | CONST_PERSISTENT);
  REGISTER_LONG_CONSTANT("PGSQL_STATUS_STRING", PGSQL_STATUS_STRING,
  CONST_CS | CONST_PERSISTENT);
  @@ -2990,6 +3004,55 @@
  }
  / }}} */
  #endif

+/* {{{ proto string pg_result_error_field(resource result, long code)

• Get diagnosis message associated with the result */
  +PHP_FUNCTION(pg_result_error_field)
  +{
• zval *result;
• long code;
• PGresult *pgsql_result;
• pgsql_result_handle *pg_result;
• char *err = NULL;
• if (zend_parse_parameters_ex(ZEND_PARSE_PARAMS_QUIET,
  ZEND_NUM_ARGS() TSRMLS_CC, "rl",

•   						 &result,
  

&code) == FAILURE) {

•   php_error_docref(NULL TSRMLS_CC, E_WARNING, "Cannot parse
  

params");

•   RETURN_FALSE;
  

• }
• if (code != PG_DIAG_SEVERITY &&

•   code != PG_DIAG_SQLSTATE &&
  

•   code != PG_DIAG_MESSAGE_PRIMARY &&
  

•   code != PG_DIAG_MESSAGE_DETAIL &&
  

•   code != PG_DIAG_MESSAGE_HINT &&
  

•   code != PG_DIAG_STATEMENT_POSITION &&
  

•   code != PG_DIAG_INTERNAL_POSITION &&
  

•   code != PG_DIAG_INTERNAL_QUERY &&
  

•   code != PG_DIAG_CONTEXT &&
  

•   code != PG_DIAG_SOURCE_FILE &&
  

•   code != PG_DIAG_SOURCE_LINE &&
  

•   code != PG_DIAG_SOURCE_FUNCTION
  

• ) {

•   php_error_docref(NULL TSRMLS_CC, E_WARNING, "Invalid diag
  

code");

•   RETURN_FALSE;
  

• }
• ZEND_FETCH_RESOURCE(pg_result, pgsql_result_handle *, &result, -1,
  "PostgreSQL result", le_result);
• pgsql_result = pg_result->result;
• if (!pgsql_result) {

•   php_error_docref(NULL TSRMLS_CC, E_WARNING, "Invalid result
  

suppied");

•   RETURN_FALSE;
  

• }
• err = (char *)PQresultErrorField(pgsql_result, code);
• RETURN_STRING(err,1);
  +}
  +/* }}} */

/* {{{ proto string pg_result_error(resource result)
Get error message associated with result */

--- ../../../../../../lang/php5/work/php-5.0.2/ext/pgsql/php_pgsql.h Thu
Jan 8 17:32:40 2004
+++ php_pgsql.h Sat Nov 13 19:50:06 2004
@@ -105,6 +105,7 @@
PHP_FUNCTION(pg_get_pid);
/* error message functions /
PHP_FUNCTION(pg_result_error);
+PHP_FUNCTION(pg_result_error_field);
PHP_FUNCTION(pg_last_error);
PHP_FUNCTION(pg_last_notice);
/ copy functions */