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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-05 20:32:24 | Re: spinlock support for Sun Studio 12 compiler on linux |
Previous Message | Tom Lane | 2007-07-05 17:45:10 | Re: BUG #3428: plperl spi_exec_prepared char length always unity |