Re: [GENERAL] Deadlock with REINDEX TABLE

2007-03-22 Thread Erik Jones
On Mar 22, 2007, at 1:01 PM, Tom Lane wrote: Erik Jones <[EMAIL PROTECTED]> writes: Mar 21 19:36:18 [info] User Info: REINDEX TABLE emma_messages_email_queue; [nativecode=ERROR: deadlock detected DETAIL: Process 12912 waits for AccessExclusiveLock on relation 138763808 of database 16384; blo

Re: [GENERAL] Deadlock with REINDEX TABLE

2007-03-22 Thread Tom Lane
Erik Jones <[EMAIL PROTECTED]> writes: > Mar 21 19:36:18 [info] User Info: REINDEX TABLE > emma_messages_email_queue; [nativecode=ERROR: deadlock detected > DETAIL: Process 12912 waits for AccessExclusiveLock on relation > 138763808 of database 16384; blocked by process 15217. > Process 1521