| From: | Mark Rae <m(dot)rae(at)inpharmatica(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Aborting transaction on error |
| Date: | 2002-03-01 16:14:45 |
| Message-ID: | 3C7FA8F5.81376487@inpharmatica.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
Why does postgres abort the current transaction on error?
Is this actually required ANSI-SQL behaviour, or just a postgres
peculiarity.
More specifically, I have some DBI scripts which under Oracle
just insert rows into a table with a unique constraint. If they
come across a duplicate row they detect and report this error and
continue. (The duplicates are discarded as they are not needed)
However in postgres, it automatically aborts the transaction, so is
checking for the existance for a duplicate row beforehand the only way
to avoid this?
-Mark
--
Mark Rae Tel: +44(0)20 7074 4648
Inpharmatica Fax: +44(0)20 7074 4700
m(dot)rae(at)inpharmatica(dot)co(dot)uk http://www.inpharmatica.co.uk/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel J. Sutjiono | 2002-03-01 16:24:49 | LIMIT and OFFSET |
| Previous Message | Johnson, Shaunn | 2002-03-01 16:04:10 | Re: check sql progress |