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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
