Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help! "alter table add column" hangs

Help! "alter table add column" hangs

From
Date:



The command

  ALTER TABLE ADD COLUMN some_column CHAR(6) UNIQUE;

hangs indefinitely (hours!), even though the table is relatively small
(about 2500 records).

What gives?

Thanks,

kj