Help! "alter table add column" hangs

From: <kynn(at)panix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Help! "alter table add column" hangs
Date: 2004-02-29 22:05:51
Message-ID: 200402292205.i1TM5pb14578@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message kynn 2004-02-29 22:07:54 Help! "alter table add column" hangs
Previous Message Markus Bertheau 2004-02-29 09:50:37 Re: pg_dumpall and convert from LATIN1 to UTF-8?