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