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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Sun, 29 Feb 2004 kynn (AT) panix (DOT) com wrote:

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?


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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

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

That's what it was. Thanks!!!

kj


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match