Error abort transaction behaviour

From: hyldgaard(at)hotmail(dot)com (Thomas Hyldgaard)
To: pgsql-general(at)postgresql(dot)org
Subject: Error abort transaction behaviour
Date: 2002-07-19 23:45:13
Message-ID: 62b0a667.0207191545.7a4c5d70@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

As I can read from other appends then the behaviour where transactions
are aborted if errors occur is "working as designed" in PostgreSQL.

This is different from the behaviour in DB/2 and Oracle (eg. they do
not abort a transaction if a dulicated key is inserted into a table)
and makes it almost impossible for me to have common code that can use
both PostgreSQL, DB/2 and Oracle.

I'm using PostgreSQL 7.2. Is this something that will be changed in a
later version of PostgreSQL?

Best regards
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anthony Berglas 2002-07-20 01:41:27 Re: Multi-Versions and Vacuum -- cf Oracle & Vacuum alt
Previous Message Oliver Elphick 2002-07-19 23:03:31 Debian stable now includes 7.2.1