thanks for the link regarding errors... i did not find it before.
On Thu, Mar 27, 2008 at 10:47 AM, Richard Huxton <
dev@archonet.com> wrote:
Alain Roger wrote:
> hi,
>
> i would like to know how can i control the returned value from a SQL
> statement ?
> for example, if i do an INSERT INTO... :
> 1. how can i know if the INSERT worked ?
> i mean i already trapped the unicity violation, but what if there is another
> error ? where can i get a complete list of exceptions ?
>
> 2. if the INSERT INTO is successful, how can i know it ? what is the
> returned value ?
If it fails you'll get an error. The transaction will be aborted. How
you access this error code will depend on what library/client you are using.
> 3. the same question as point 2 but for all SQL statements from PostgreSQL.
Same.
> I read few books and every time this part is not treated correctly but only
> partially.
There's a full list of error codes here if you want to know what went wrong:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html
Am I mis-understanding you?
--
Richard Huxton
Archonet Ltd
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
