Terry Fielder <terry@xxxxxxxxxxxxxxxxxxxx> writes: > I am getting this in my log file: > 2006-10-05 16:06:23 [6469] ERROR: deadlock detected > DETAIL: Process 6469 waits for ShareLock on transaction 668582701; > blocked by process 28763. > Process 28763 waits for ShareLock on transaction 668586325; > blocked by process 6469. > I believe that the elements "a" and "b" are different tables. Actually, what you're looking at there is a conflict on row-level locks being obtained in opposite orders. What PG version is this? If it's 8.1 you can identify the row in question from other entries in pg_locks, but if it's older then there's no easy way to find out. regards, tom lane
