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

Re: Error code

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Error code
Date: 2009-09-22 15:08:35
Message-ID: 20090922110835.a8c5b2b4.wmoran@potentialtech.com (view raw or flat)
Thread:
Lists: pgsql-php
In response to Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com>:

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

That's fine.  Note, however, that those codes are not numeric.
Also, you'll be better served putting them in constants, to avoid
bugs where the values are accidentally changed.

> 
> 
> ------------------------ 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


-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

In response to

  • Re: Error code at 2009-09-22 14:20:11 from Gustavo Amarilla Santacruz

Responses

  • Re: Error code at 2009-09-22 15:54:27 from Gustavo Amarilla Santacruz

pgsql-php by date

Next:From: Gustavo Amarilla SantacruzDate: 2009-09-22 15:54:27
Subject: Re: Error code
Previous:From: Gustavo Amarilla SantacruzDate: 2009-09-22 14:20:11
Subject: Re: Error code

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