Skip site navigation (1) Skip section navigation (2)

Re: Error code

From: Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Error code
Date: 2009-09-22 14:20:11
Message-ID: e4ea2d810909220720i38860764sd5366878325cd4f2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-php
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

In response to

Responses

pgsql-php by date

Next:From: Bill MoranDate: 2009-09-22 15:08:35
Subject: Re: Error code
Previous:From: Bill MoranDate: 2009-09-22 13:38:15
Subject: Re: Error code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group