Date: Mon, 03 Jul 2006 08:30:01 +1000
From: Hima Surapaneni <hbsur1@student.monash.edu>
Subject: Can't drop table
To: pgsql-sql@postgresql.org
Message-id: <203.39.118.63.1151878450@my.monash.edu.au>
MIME-version: 1.0
Content-type: text/plain
Content-transfer-encoding: 7BIT
Content-disposition: inline

Hi,

I have created a table called experimenters with the following query:

CREATE TABLE experimenters (
      experimenter_id  INTEGER CONSTRAINT firstkey PRIMARY KEY,
      first_name       CHAR(20),
      last_name        CHAR(25),
      address          CHAR(30),
      phone_num        CHAR(15)
);

The query was successful. But when I try to drop or alter the table, it just hangs without echoing any error message. I have to cancel the query to get out.

I ran the following query to drop the table

DROP TABLE experimenters;

It also hangs when I try to alter the table.

Just don't understand the problem here.

Any help will be highly appreciated.

Thanks in advance

Hima