Re: [ADMIN] Clearing locks

2010-06-07 Thread Matthew Excell
That did it. Thanks! Matthew Excell On Mon, Jun 7, 2010 at 1:46 PM, Alvaro Herrera wrote: > Excerpts from Matthew Excell's message of lun jun 07 15:33:27 -0400 2010: > > I'm on PostgreSQL 8.3.11 on Debian. > > > > I have a small piece of DDL (alter table title drop column is_target) > that > >

Re: [ADMIN] Clearing locks

2010-06-07 Thread Alvaro Herrera
Excerpts from Matthew Excell's message of lun jun 07 15:33:27 -0400 2010: > I'm on PostgreSQL 8.3.11 on Debian. > > I have a small piece of DDL (alter table title drop column is_target) that > hangs "waiting" forever. (I've waited hours - it still shows as waiting in > pg_top.) I have restarted t

[ADMIN] Clearing locks

2010-06-07 Thread Matthew Excell
I'm on PostgreSQL 8.3.11 on Debian. I have a small piece of DDL (alter table title drop column is_target) that hangs "waiting" forever. (I've waited hours - it still shows as waiting in pg_top.) I have restarted the database - even tried it in single-user mode - but it still waits. When I execut