Re: SELECT FOR UPDATE....LIMIT ...broken - Mailing list pgsql-general

From Darren Govoni
Subject Re: SELECT FOR UPDATE....LIMIT ...broken
Date
Msg-id 1231695010.1239.69.camel@nuraku
Whole thread Raw
In response to Re: SELECT FOR UPDATE....LIMIT ...broken  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Well, I did, but I clicked the link to Chapter 13 before scrolling down
further to see the Caution section. Heheh.

Thanks for the heads up.

On Sun, 2009-01-11 at 12:12 -0500, Tom Lane wrote:
> Darren Govoni <darren@ontrenet.com> writes:
> > This seems like a bug to me. Is it fixed in the current dev build? Or is
> > there something else I'm missing?
>
> I think you have not read the documentation about FOR UPDATE and LIMIT
> on the SELECT reference page:
> http://www.postgresql.org/docs/8.3/static/sql-select.html#SQL-FOR-UPDATE-SHARE
> Note the second CAUTION block in particular.
>
>             regards, tom lane
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT FOR UPDATE....LIMIT ...broken
Next
From: "Joshua D. Drake"
Date:
Subject: Re: compile of 8.1.15