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

From Don Morrison
Subject Re: Conditional INSERT: if not exists
Date
Msg-id aee6519f0608231405u13b16147v3ae2cdb5a158e102@mail.gmail.com
Whole thread Raw
In response to Re: Conditional INSERT: if not exists  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Conditional INSERT: if not exists  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
> If you know there won't be concurrent inserts or deletes affecting the
> row of interest there is a way to do this in the INSERT statement.

I cannot rule out concurrent inserts.

> > transaction...I'm not sure the nested transaction is necessary...maybe
> > just the savepoint. Example:
> Using save points creates nested transactions, so you have that overhead by
> whatever name it is called.

Overhead yes, that was not the question.  The question was is the
extra nesting necessary?

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Conditional INSERT: if not exists
Next
From: Sean Davis
Date:
Subject: Re: Conditional INSERT: if not exists