Postgres Pro
Downloads
Home   >   mailing lists

Re: skip duplicate key error during inserts - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: skip duplicate key error during inserts
Date
Msg-id 65937bea0610270448h53947dbbge001af942e51dbd8@mail.gmail.com
Whole thread Raw
In response to Re: skip duplicate key error during inserts  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: skip duplicate key error during inserts  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view


On 10/27/06, Ron Johnson <ron.l.johnson@cox.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[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

pgsql-general by date:

Previous
From: Edward Macnaghten
Date:
Subject: Re: UK Hosting Providers
Next
From: Ron Johnson
Date:
Subject: Re: skip duplicate key error during inserts