On Sun, 29 Feb 2004 kynn(at)panix(dot)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?