Re: BUG #5254: can't drop a table

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