Обсуждение: BUG #5254: can't drop a table

The following bug has been logged online:

Bug reference:      5254
Logged by:          fwoncn
Email address:      fwoncn@gmail.com
PostgreSQL version: 8.3
Operating system:   Windows XP
Description:        can't drop a table
Details:

I created a table named 'order' which is a reserved word in SQL by mistake
in the pgAdmin bundled with the official distribution. and now a can't drop
it in whatever way. in pgAdmin, the program hangs up when i click on that
table. and i can't drop it using the SQL line: drop table order, cuz order
is a reserved word and it's a wrong command.
I think it's definitely a bug.

fwoncn wrote:
> I created a table named 'order' which is a reserved word in SQL by mistake
> in the pgAdmin bundled with the official distribution. and now a can't drop
> it in whatever way. in pgAdmin, the program hangs up when i click on that
> table. and i can't drop it using the SQL line: drop table order, cuz order
> is a reserved word and it's a wrong command.
> I think it's definitely a bug.

Dunno about the pgAdmin issue, but try double-quoting the table name:

DROP TABLE "order";

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

On Wed, 2009-12-23 at 15:49 +0000, fwoncn wrote:
> I created a table named 'order' which is a reserved word in SQL by
> mistake in the pgAdmin bundled with the official distribution. and now
> a can't drop it in whatever way. in pgAdmin, the program hangs up when
> i click on that table. and i can't drop it using the SQL line: drop
> table order, cuz order is a reserved word and it's a wrong command.

Add double quotes around order:

DROP TABLE "order";

--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz