Search Postgresql Archives

Re: skip duplicate key error during inserts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Ron Johnson" <ron.l.johnson@xxxxxxx>
Subject: Re: skip duplicate key error during inserts
From: "Gurjeet Singh" <singh.gurjeet@xxxxxxxxx>
Date: Fri, 27 Oct 2006 17:18:46 +0530
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <4541E7FC.5050909@xxxxxxx>
References: <20061020150150.14462.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx> <8c0cc2820610220239r62ff82dap95d756e17bfe8413@xxxxxxxxxxxxxx> <453B46EE.3050001@xxxxxxx> <65937bea0610270241g41a7c8dbr85f7edb9ddc70df@xxxxxxxxxxxxxx> <4541D7B5.7030606@xxxxxxx> <65937bea0610270310n2a95260ub0e5ddc4f7499b14@xxxxxxxxxxxxxx> <4541E7FC.5050909@xxxxxxx>

On 10/27/06, Ron Johnson <ron.l.johnson@xxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: skip duplicate key error during inserts
  - From: Ron Johnson

References:
- skip duplicate key error during inserts
  - From: Jean-Christophe Roux
- Re: skip duplicate key error during inserts
  - From: Jeffrey Webster
- Re: skip duplicate key error during inserts
  - From: Ron Johnson
- Re: skip duplicate key error during inserts
  - From: Gurjeet Singh
- Re: skip duplicate key error during inserts
  - From: Ron Johnson
- Re: skip duplicate key error during inserts
  - From: Gurjeet Singh
- Re: skip duplicate key error during inserts
  - From: Ron Johnson

Prev by Date: Re: UK Hosting Providers
Next by Date: Instead of Triggers
Previous by thread: Re: skip duplicate key error during inserts
Next by thread: Re: skip duplicate key error during inserts
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]