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:07:54
Message-ID: 200402292207.i1TM7sR14765@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Thanks,

kj

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Cath Lawrence 2004-02-29 23:36:19 Huge query help
Previous Message kynn 2004-02-29 22:05:51 Help! "alter table add column" hangs