Re: SELECT FOR UPDATE

Thomas Swan wrote:
> When a SELECT FOR UPDATE query is executed, are the row level locks on a 
> table acquired in any specific order such as to enhance deadlock 
> prevention? ( primary key, oid, etc. )

Interesting question, because in a join, you could have multiple tables
involved.  Sorry, I don't know the answer.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073