BUG #3429: table named MULTIPOLYGON

From: "James White" <jbw20032(at)earthlink(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3429: table named MULTIPOLYGON
Date: 2007-07-05 17:19:48
Message-ID: 200707051719.l65HJmfk007862@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3429
Logged by: James White
Email address: jbw20032(at)earthlink(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-07-05 17:45:10 Re: BUG #3428: plperl spi_exec_prepared char length always unity
Previous Message Matt Taylor 2007-07-05 17:16:33 Re: BUG #3428: plperl spi_exec_prepared char length always unity