Craig James <craig_james(at)emolecules(dot)com> 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

In response to

• select for update at 2011-04-22 17:49:54 from Craig James

Responses

• Re: select for update at 2011-04-22 23:10:36 from Craig James

pgsql-admin by date

Next:	From: Craig James	Date: 2011-04-22 23:10:36
	Subject: Re: select for update
Previous:	From: Kevin Grittner	Date: 2011-04-22 20:25:05
	Subject: Re: select for update