Re: [ADMIN] select for update

Fri, 22 Apr 2011 16:11:11 -0700 

On 4/22/11 1:58 PM, Tom Lane wrote:

Craig James<[email protected]>  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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to