Thread: Help! "alter table add column" hangs

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

On Sun, 29 Feb 2004 kynn@panix.com wrote:

> 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?

This likely means that some other transaction has a lock on some_table.
What does
 select * from pg_locks where relation=(select oid from pg_class
  where relname='some_table')
show?

   X-Original-To: kynn@panix.com
   Date: Sun, 29 Feb 2004 16:43:05 -0800 (PST)
   From: Stephan Szabo <sszabo@megazone.bigpanda.com>
   Cc: pgsql-novice@postgresql.org

   This likely means that some other transaction has a lock on some_table.

That's what it was.  Thanks!!!

kj