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

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

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

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@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailtogsql-bugs-owner@postgresql.org] 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: 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

---------------------------(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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Jul 05, 2007 at 03:22:17PM -0500, Larry Rosenman wrote:
> 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@lerctr.org
> US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>
> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org
> [mailtogsql-bugs-owner@postgresql.org] 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: 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

Sorry, I do't know what the above command does, but it seems to create
the table with an uppercase name. Then...

>
> Using the \dt command I get a line
>
> public | MULTIPOLYGON | table | postgres
>
> However with this command
>
> swgap=# \d multipolygon

.... just try here \d "MULTIPOLYGON" (with double quotes). This should
work.

PostgreSQL's representation of "case insensitive" names is actually
lower-case. Thus if you use a name unquoted, it'll be implicitly
converted to lower case.

HTH
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGjbt2Bcgs9XrR2kYRArfLAJ4hVR8PAxl5Fnn+1OMfJm yHL/X2EQCfSfgy
CsZnEfiCna0tXGclY7emzNA=
=3n6X
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend