Re: conditional insert

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: conditional insert
Date: 2011-09-07 20:04:54
Message-ID: 20110907200454.GV35347@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 07, 2011 at 02:51:32PM -0500, Merlin Moncure wrote:
>
> @andrew s: going SERIALIZABLE doesn't help if you trying to eliminate
> cases that would push you into retrying the transaction.

Well, no, of course. But why not catch the failure and retry? I
guess I just don't get the problem, since I hear people say this all
the time. (I mean, I've also seen places where 'upsert' would be
cool, but it doesn't seem trivial to do in a general way and you can
do this with catch-serialization-error-and-retry, I think?)

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arun Nadar 2011-09-07 20:45:28 Problem using PostgreSQL 9.0.4 with Java
Previous Message Merlin Moncure 2011-09-07 19:51:32 Re: conditional insert