Re: Insert Ignore or something similar... - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Insert Ignore or something similar...
Date
Msg-id 20050906035142.GD22392@surnet.cl
Whole thread Raw
In response to Re: Insert Ignore or something similar...  ("Thomas F. O'Connell" <tfo@sitening.com>)
Responses Re: Insert Ignore or something similar...
List pgsql-general
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
> I don't think any such behavior exists in PostgreSQL, and based on a
> reading of the behavior in MySQL, I can't imagine it ever existing
> considering the preference of PostgreSQL developers for correct (and
> sane) behavior. INSERT IGNORE seems like a foot-cannon...

What is it supposed to do?  If ignoring errors is the behavior Cristian
wants, it's possible to do with savepoints (or PL/pgSQL exceptions).

--
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"People get annoyed when you try to debug them."  (Larry Wall)

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: Insert Ignore or something similar...
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: Insert Ignore or something similar...