From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Hima Surapaneni <hbsur1(at)student(dot)monash(dot)edu>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Can't drop table |
Date: | 2006-07-03 02:30:00 |
Message-ID: | 20060703023000.52836.qmail@web31805.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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.
You might want to post this on the PG_General Mailing list of you do not get many responses.
Regards,
Richard Broersma Jr.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-07-03 03:23:41 | Re: Can't drop table |
Previous Message | Phillip Smith | 2006-07-03 02:16:04 | Re: join two tables with sharing some columns between two |