Re: Error code

Thank you, Bill.
I can not use the numeric error code such as 23505 ( by coding convention );
I need to do this:

------------------------ CODE
-----------------------------------------------------------

include( "PostgresqlErrorList.php" );
.
.
.
if( $errorCode == $UNIQUE_VIOLATION )
echo( "message" );

------------------------ CODE
-----------------------------------------------------------

Here, "PostgresqlErrorList.php" is a file included in PHP libraries. This
file would can contain code such as:

<php?
$UNIQUE_VIOLATION = 23505;
$DATETIME_FIELD_OVERFLOW = 22008;
.
.
.
?>

Exists this file for in Postgresql-PHP library?

On Tue, Sep 22, 2009 at 9:38 AM, Bill Moran <wmoran(at)potentialtech(dot)com>wrote:

> In response to Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com>:
>
> > Thank you, Chris.
> > Now, I need to do this in PHP:
> >
> > -------------------- CODE
> > ---------------------------------------------------------------
> >
> > $errorCode = pg_result_error_field($res1, PGSQL_DIAG_SQLSTATE) ;
> >
> > if( $errorCode == UNIQUE_VIOLATION )
>
> if ( $errorCode == '23505' )
>
> --
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/
>

--
Gustavo Amarilla
ISMEB