I have been looking for a resource on how to do proper error handling with
PostgreSQL connections and queries. In one specific case, I have a
referential integrity constraint on a table. When I try to delete from that
table, it fails, as it should, when there is something referring to the
entry I am trying to erase. All fine and dandy.

Problem is, I don't think pg_last_error() is a proper way to notify the user
that they need to revise how they are proceeding with their action. In other
words, I want to first DETECT that the integrity constraint has been
violated (I am most likely to know why it has happened), and then print to
the user a message the user will understand. (If the user were indeed a
programmer, I supposed pg_last_error() would be fine indeed)

So, is there any resource I can look at that is not only a tutorial but also
provides a complete reference as to how to handle such errors? Everywhere I
have looked there is only simple stuff like "How to connect to your PG
Database" or "How to get data from your database". It would be much
appreciated if there was some resource to be share that fully explains how
to do error handling on the web somewhere!

Your time is much appreciated,

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to