| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | fwoncn <fwoncn(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5254: can't drop a table |
| Date: | 2009-12-24 22:20:11 |
| Message-ID: | 1261693211.2594.17.camel@hp-laptop2.gunduz.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matteo Beccati | 2009-12-25 10:43:40 | BUG #5255: COUNT(*) returns wrong result with LEFT JOIN |
| Previous Message | Heikki Linnakangas | 2009-12-23 17:38:46 | Re: BUG #5254: can't drop a table |