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

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