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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])