Re: select for update

[Craig James <craig_james@xxxxxxxxxxxxxx>]

On 4/22/11 1:58 PM, Tom Lane wrote:
> Craig James<craig_james@xxxxxxxxxxxxxx>  writes:
> >     select objectid from archive where db_id is null limit 1 for update
> The interaction between LIMIT and FOR UPDATE changed in 9.0 ... what
> PG version are you using?
8.4.4

thanks,
Craig
> 			regards, tom lane


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin