Re: unique index

On Mon, Feb 27, 2006 at 06:11:07PM -0300, Gus List wrote:
> The problem is that when I try to insert an duplicate entry for testing I
> receive te error (ERROR:  duplicate key violates unique constraint
> "new_idx_UNIQ") but ALL RECORDS are DELETED. I don't think that this should
> happen.

Are you in a transaction?  If so then the error is causing the
transaction to fail, which causes all of the transaction's work to
be rolled back (discarded).  That's how transactions work: either
everything succeeds or nothing does.  However, it's possible to
continue a transaction after an error if you use savepoints.

http://www.postgresql.org/docs/8.1/interactive/tutorial-transactions.html
http://www.postgresql.org/docs/8.1/interactive/sql-savepoint.html

--
Michael Fuhr