Re: Help! "alter table add column" hangs - Mailing list pgsql-novice

On Sun, 29 Feb 2004 kynn@panix.com wrote:

> Sorry, I had meant to write:
>
>   The command
>
>     ALTER TABLE some_table ADD COLUMN some_column CHAR(6) UNIQUE;
>                 ^^^^^^^^^^
>   hangs indefinitely (hours!), even though the table is relatively small
>   (about 2500 records).
>
>   What gives?

This likely means that some other transaction has a lock on some_table.
What does
 select * from pg_locks where relation=(select oid from pg_class
  where relname='some_table')
show?