Re: select for update - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: select for update
Date
Msg-id 4DB19DD1020000250003CC02@gw.wicourts.gov
Whole thread Raw
In response to select for update  (Craig James <craig_james@emolecules.com>)
List pgsql-admin
Craig James <craig_james@emolecules.com> wrote:

> The sequence of operations goes like this (pseudo-code):

> The problem is that very occasionally the same ID will be issued
> twice.  I don't see how this can be.  Doesn't the "for update"
> guarantee that no other process can claim that same row?

I don't see a flaw in the pseudo-code (other than an apparent typo
on the insert).  Can you show the actual code?

-Kevin

pgsql-admin by date:

Previous
From: Craig James
Date:
Subject: select for update
Next
From: Tom Lane
Date:
Subject: Re: select for update