ff@xxxxxxxxx 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.