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

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

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-01-11 19:52:40 PostgreSQL Conference / PgCon.US update
Previous Message Tom Lane 2009-01-11 17:12:50 Re: SELECT FOR UPDATE....LIMIT ...broken