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? 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
