pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't drop table
3+ messages / 3 participants
[nested] [flat]
* Can't drop table
@ 2006-07-02 22:30 Hima Surapaneni <hbsur1@student.monash.edu>
2006-07-03 02:30 ` Re: Can't drop table Richard Broersma Jr <rabroersma@yahoo.com>
2006-07-03 03:23 ` Re: Can't drop table Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Hima Surapaneni @ 2006-07-02 22:30 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't drop table
2006-07-02 22:30 Can't drop table Hima Surapaneni <hbsur1@student.monash.edu>
@ 2006-07-03 02:30 ` Richard Broersma Jr <rabroersma@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Broersma Jr @ 2006-07-03 02:30 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't drop table
2006-07-02 22:30 Can't drop table Hima Surapaneni <hbsur1@student.monash.edu>
@ 2006-07-03 03:23 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2006-07-03 03:23 UTC (permalink / raw)
To: Hima Surapaneni <hbsur1@student.monash.edu>; +Cc: pgsql-sql
Hima Surapaneni <hbsur1@student.monash.edu> writes:
> 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.
Sounds like there's some open transaction with a lock on the table.
The pg_locks view might help you figure out which one.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-07-03 03:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-02 22:30 Can't drop table Hima Surapaneni <hbsur1@student.monash.edu>
2006-07-03 02:30 ` Richard Broersma Jr <rabroersma@yahoo.com>
2006-07-03 03:23 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox