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 <[email protected]>wrote:

> In response to Gustavo Amarilla Santacruz <[email protected]>:
>
> > 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