Re: Select after insert to the unique column - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Select after insert to the unique column
Date
Msg-id 20041213164425.GB546@wolff.to
Whole thread Raw
In response to Re: Select after insert to the unique column  (juleni@livetrade.cz)
List pgsql-general
On Mon, Dec 13, 2004 at 17:04:17 +0100,
  juleni@livetrade.cz wrote:
> Thank you for your answer. I think it's very interesting behaviour. Is
> it a feature or bug ?

Until version 8 (which is in release candidate status now), there was
no way to recover from an error within a transaction other than aborting
the transaction. With version 8 you will be able to use savepoints to
allow for recovery from errors within a transaction.

The best answer to your question above, is that it is a limitation and
not really a feature and definitely not a bug.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: table with sort_key without gaps
Next
From: Hans-Michael Stahl
Date:
Subject: "Complex" data types like BYTEA in embedded SQL with ecpg