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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
