Re: [HACKERS] Possible bugreport 8.3 beta1 on Win32: Looking like a deadlock with AutoVacuum

2007-10-10 Thread Deblauwe Gino
Alvaro Herrera schreef: Deblauwe Gino wrote: OS: Windows XP Pro SP2 CPU: AMD Athlon 64 3500+ RAM: 2GB DB: PostgreSQL 8.3beta1, compiled by Visual C++ build 1400 I've come to the conclusion that it seems like a deadlock occurs when dropping a column in a table the same moment that table is a

Re: [HACKERS] Possible bugreport 8.3 beta1 on Win32: Looking like a deadlock with AutoVacuum

2007-10-09 Thread Alvaro Herrera
Deblauwe Gino wrote: > OS: Windows XP Pro SP2 > CPU: AMD Athlon 64 3500+ > RAM: 2GB > DB: PostgreSQL 8.3beta1, compiled by Visual C++ build 1400 > > I've come to the conclusion that it seems like a deadlock occurs when > dropping a column in a table the same moment that table is autovacuumed. > >

[HACKERS] Possible bugreport 8.3 beta1 on Win32: Looking like a deadlock with AutoVacuum

2007-10-09 Thread Deblauwe Gino
OS: Windows XP Pro SP2 CPU: AMD Athlon 64 3500+ RAM: 2GB DB: PostgreSQL 8.3beta1, compiled by Visual C++ build 1400 I've come to the conclusion that it seems like a deadlock occurs when dropping a column in a table the same moment that table is autovacuumed. Example: ALTER TABLE bondetail DRO