Home > mailing lists

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

From
Subject	Help! "alter table add column" hangs
Date	February 29, 2004 18:06:02
Msg-id	200402292205.i1TM5pb14578@panix3.panix.com Whole thread Raw
List	pgsql-novice

Tree view




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

pgsql-novice by date:

From: Markus Bertheau
Date: 29 February 2004, 05:51:19
Subject: Re: pg_dumpall and convert from LATIN1 to UTF-8?

From:
Date: 29 February 2004, 18:08:00
Subject: Help! "alter table add column" hangs

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

Previous

Next