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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
