Re: sql problem with php - Mailing list pgsql-php

From ljb
Subject Re: sql problem with php
Date
Msg-id cmha2i$rjt$1@news.hub.org
Whole thread Raw
In response to sql problem with php  (Flavio Fonseca <ff@dr.ufu.br>)
Responses Re: sql problem with php  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-php
ff@dr.ufu.br wrote:
> Hi,
>
>   I am having a problem with a system I developed using php with postgres.
>...
>
> I am not able to get a error_number in pgsql errors, only the error message.
> So when I used pgsql 7.3 a used the string "referential integrity violation"
> to detect this error, but on version 7.4 of pgsql this string was replaced
> with "violates foreign key constraint" .
> Anyone has a definitive solution on this or the way is to wait and change all
> my code on future releases of pgsql?

Unfortunately this is a limitation of the PHP PostgreSQL extension.
PostgreSQL provids access to error numbers (I think as of 7.4)
through libpq PQerrorField(), but PHP doesn't give you access to this yet.

pgsql-php by date:

Previous
From: Flavio Fonseca
Date:
Subject: sql problem with php
Next
From: Robert Treat
Date:
Subject: Re: sql problem with php