The following bug has been logged online:
Bug reference: 3429
Logged by: James White
Email address: jbw20032@earthlink.net
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