Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: SELECT FOR UPDATE....LIMIT ...broken
Date
Msg-id 22319.1231693970@sss.pgh.pa.us
Whole thread Raw
In response to SELECT FOR UPDATE....LIMIT ...broken  (Darren Govoni <darren@ontrenet.com>)
Responses Re: SELECT FOR UPDATE....LIMIT ...broken  (Darren Govoni <darren@ontrenet.com>)
List pgsql-general
Tree view 
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: Darren Govoni
Date:
Subject: SELECT FOR UPDATE....LIMIT ...broken
Next
From: Darren Govoni
Date:
Subject: Re: SELECT FOR UPDATE....LIMIT ...broken