try: DROP TABLE "MULTIPOLYGON"; That should do it. (pardon the top post).
-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James White Sent: Thursday, July 05, 2007 12:20 PM To: pgsql-bugs@postgresql.org Subject: [BUGS] BUG #3429: table named MULTIPOLYGON The following bug has been logged online: Bug reference: 3429 Logged by: James White Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: debian etch amd64 Description: table named MULTIPOLYGON Details: I accidentally created a table name multipolygon with the typo: ogr2ogr -f "PostgreSQL" -nln sw_watersheds -nln MULTIPOLYGON PG:dbname=swgap USGSwatersheds.shp Using the \dt command I get a line public | MULTIPOLYGON | table | postgres However with this command swgap=# \d multipolygon Did not find any relation named "multipolygon". swgap=# \dt multipolygon No matching relations found. I cannot drop this table ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
