Problem running "ALTER TABLE...", ALTER TABLE waiting

From: Brian McNally <bmcnally(at)uw(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem running "ALTER TABLE...", ALTER TABLE waiting
Date: 2012-07-17 19:54:01
Message-ID: 5005C2D9.7050305@uw.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm running Postgres 9.0.2 on RHEL 5.6 x86_64 and trying to run the
following statement:

alter table samples add column in_esp1234 text;

When I do this the command just hangs. ps output indicates that it's
waiting:

postgres: postgres exomeSNP [local] ALTER TABLE waiting

When I look to see what might have that table locked I don't see anything:

select * from pg_locks where relation=(select oid from pg_class where
relname='samples');

I have a nearly identical server where this command works. It seems like
something has this table locked, but I haven't been able to find it. Any
ideas?

Thanks for any help,

--
Brian McNally

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2012-07-17 23:41:15 Chicken/egg problem with range types
Previous Message Olga Vingurt 2012-07-17 13:37:15 Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.