Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?




pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group