Re: SELECT FOR UPDATE and LIMIT 1 behave oddly

Bruce,

Ah, yes, which reminds me I need to generate that doc patch.

> I am wondering if a documentation warning about the use of FOR UPDATE
> and LIMIT is a good idea.  If we can't be sure the LIMIT will return a
> guaranteed number of rows, should we just disallow that combination?  I
> realize such a case is rare.  Should we emit a warning when it happens?

Well, limit+for update can be useful under some circumstances, as long as you
understand its limitations.    We found a workaround.  So I'd oppose
disallowing it.

--
Josh Berkus
Aglio Database Solutions
San Francisco