Re: SELECT FOR UPDATE....LIMIT ...broken

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darren Govoni <darren(at)ontrenet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT FOR UPDATE....LIMIT ...broken
Date: 2009-01-11 17:12:50
Message-ID: 22319.1231693970@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darren Govoni <darren(at)ontrenet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Govoni 2009-01-11 17:30:10 Re: SELECT FOR UPDATE....LIMIT ...broken
Previous Message Darren Govoni 2009-01-11 17:00:00 SELECT FOR UPDATE....LIMIT ...broken