Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: skip duplicate key error during inserts

  • From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
  • To: "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: skip duplicate key error during inserts
  • Date: Fri, 27 Oct 2006 17:18:46 +0530
  • Message-id: <65937bea0610270448h53947dbbge001af942e51dbd8(at)mail(dot)gmail(dot)com>


On 10/27/06, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
Dueling examples.  Attached are two examples of errors.

I think you completely missed that I am recommending using '\set ON_ERROR_ROLLBACK on' in psql.

Please refer to my previous post and see the effect of the following line:

postgres=# \set ON_ERROR_ROLLBACK on



--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | yahoo }.com
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group