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: 200402292207.i1TM7sR14765@panix3.panix.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group