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: 2006-10-27 11:48:46
Message-ID: 65937bea0610270448h53947dbbge001af942e51dbd8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chelliah gabriel - Sun Microsystems - Bangalore India 2006-10-27 12:19:19 Instead of Triggers
Previous Message Edward Macnaghten 2006-10-27 11:46:59 Re: UK Hosting Providers