| From: | Hima Surapaneni <hbsur1(at)student(dot)monash(dot)edu> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Subject: | Can't drop table | 
| Date: | 2006-07-02 22:30:01 | 
| Message-ID: | 203.39.118.63.1151878450@my.monash.edu.au | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-07-03 01:50:25 | Re: Alternative to Select in table check constraint | 
| Previous Message | Carlos H. Reimer | 2006-07-02 12:52:35 | RES: Left join? |