Re: Conditional INSERT: if not exists - Mailing list pgsql-novice

From Don Morrison
Subject Re: Conditional INSERT: if not exists
Date
Msg-id aee6519f0608231445h4e623a2xda2ecf1f48a6cfe6@mail.gmail.com
Whole thread Raw
In response to Re: Conditional INSERT: if not exists  (Sean Davis <sdavis2@mail.nih.gov>)
Responses Re: Conditional INSERT: if not exists
List pgsql-novice
> isn't a problem.  If you need to do this in a transaction, you can
> simply set savepoints and roll back to the savepoint if an insert fails
> (and you expected that it could).

Unfortunately, for some reason it does a rollback of the entire outer
transaction too, not just the nested one. :(  Anybody know why?

If I use stored procedures will it be easier?

pgsql-novice by date:

Previous
From: "Don Morrison"
Date:
Subject: Re: Conditional INSERT: if not exists
Next
From: "Don Morrison"
Date:
Subject: Re: Conditional INSERT: if not exists