Re: Abort Transaction DP PK (again) - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Abort Transaction DP PK (again)
Date
Msg-id 200308080937.34002.josh@agliodbs.com
Whole thread Raw
In response to Abort Transaction DP PK (again)  ("alexandre :: aldeia digital" <alexandre@aldeiadigital.com.br>)
Responses Re: Abort Transaction DP PK (again)  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
List pgsql-sql
Alexandre,

> I know that this topic was discuted before but I like an alternative for
> my high load INSERT query.
> Why Postgres abort a transaction when find a duplicate PK ?!?!

Postgres currently aborts a transaction upon *any* error condition, except 
warnings.  We do not, currently, have a exception-handling model for 
procedure code.  It's on the TODO list.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: Jonathan Gardner
Date:
Subject: Re: RI_ConstraintTrigger_11264756
Next
From: "Eric Anderson Vianet SAO"
Date:
Subject: unexpected chunk value