On Tue, Sep 06, 2005 at 08:55:26AM -0600, Cristian Prieto wrote:
> 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...
SAVEPOINT foo;
INSERT ... ;
if it fails
ROLLBACK TO foo;
else
RELEASE foo
Thi
ra" <[EMAIL PROTECTED]>
Cc: "Cristian Prieto" <[EMAIL PROTECTED]>;
Sent: Monday, September 05, 2005 10:01 PM
Subject: Re: [GENERAL] 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
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 Postgre
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) behav
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... --Thomas F. O'ConnellCo-Founder, Inf
Hello everybody,
I've just wondered if there are any way to
implement an INSERT IGNORE in PostgreSQL, I know, I could catch an exception in
PL/pgSQL and just handle it in the right way, but I would need to write a SP for
the task. I've been lookin into the documentation and I found no simil
