Re: Can't drop table
От | Richard Broersma Jr |
---|---|
Тема | Re: Can't drop table |
Дата | |
Msg-id | 20060703023000.52836.qmail@web31805.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Can't drop table (Hima Surapaneni <hbsur1@student.monash.edu>) |
Список | 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.
В списке pgsql-sql по дате отправления: