Thanks a lot!
Well, I just want to avoid a begin...exception when... end block in plpgsql,
just do it in a few lines of code without a sp...
Thanks a lot again!
----- Original Message -----
From: "Thomas F. O'Connell" <tfo@xxxxxxxxxxxx>
To: "Alvaro Herrera" <alvherre@xxxxxxxxxxxxxx>
Cc: "Cristian Prieto" <cristian@xxxxxxxxxxxxxxx>;
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, September 05, 2005 10:01 PM
Subject: Re: Insert Ignore or something similar...
On Sep 5, 2005, at 10:51 PM, Alvaro Herrera wrote:
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).
Yeah, I think savepoints might be his best bet. It sounded like he
was explicitly trying to avoid PL/pgSQL.
Cristian, here's a pointer to the SAVEPOINT docs:
http://www.postgresql.org/docs/8.0/static/sql-savepoint.html
I was mostly remarking that I couldn't envision a flipped switch for
incorrect/non-standard INSERT behavior.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
