Re: [GENERAL] SELECT FOR UPDATE....LIMIT ...broken

2009-01-11 Thread Darren Govoni
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 writes: > > This seems like a bug to me. Is it fixed in the current dev build? Or is > >

Re: [GENERAL] SELECT FOR UPDATE....LIMIT ...broken

2009-01-11 Thread Tom Lane
Darren Govoni 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-F

[GENERAL] SELECT FOR UPDATE....LIMIT ...broken

2009-01-11 Thread Darren Govoni
Hi, I have a simple scenario that is producing incorrect results with 8.3,ubuntu. I have queries attempting the same "select-for update limit 1". at the same time. There are 2 rows in my test database. The first will enter the transaction and only update ONE of the rows it selected, because it u