Skip site navigation (1) Skip section navigation (2)

Re: BUG #3429: table named MULTIPOLYGON

From: "Larry Rosenman" <ler(at)lerctr(dot)org>
To: "'James White'" <jbw20032(at)earthlink(dot)net>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3429: table named MULTIPOLYGON
Date: 2007-07-05 20:22:17
Message-ID: 023101c7bf42$353c27b0$9fb47710$@org (view raw or flat)
Thread:
Lists: pgsql-bugs
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: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

-----Original Message-----
From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of James White
Sent: Thursday, July 05, 2007 12:20 PM
To: pgsql-bugs(at)postgresql(dot)org
Subject: [BUGS] BUG #3429: table named MULTIPOLYGON


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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-07-05 20:32:24
Subject: Re: spinlock support for Sun Studio 12 compiler on linux
Previous:From: Tom LaneDate: 2007-07-05 17:45:10
Subject: Re: BUG #3428: plperl spi_exec_prepared char length always unity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group