Re: Abort Transaction DP PK (again)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "alexandre :: aldeia digital" <alexandre(at)aldeiadigital(dot)com(dot)br>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Abort Transaction DP PK (again)
Date: 2003-08-08 16:37:33
Message-ID: 200308080937.34002.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Eric Anderson Vianet SAO 2003-08-08 17:40:42 unexpected chunk value
Previous Message Jonathan Gardner 2003-08-08 16:30:56 Re: RI_ConstraintTrigger_11264756