Postgres Pro
Downloads
Home   >   mailing lists

Re: select for update - Mailing list pgsql-admin

From Craig James
Subject Re: select for update
Date
Msg-id 4DB20AEC.90400@emolecules.com
Whole thread Raw
In response to Re: select for update  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: select for update
List pgsql-admin
Tree view 
On 4/22/11 1:58 PM, Tom Lane wrote:
> Craig James<craig_james@emolecules.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?
8.4.4

thanks,
Craig
>             regards, tom lane
>

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: select for update
Next
From: Brian Fehrle
Date:
Subject: archive_timeout behavior (8.4.6)