Thread: 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
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 [mailto:pgsql-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
-----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 > [mailto:pgsql-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+1OMfJmyHL/X2EQCfSfgy CsZnEfiCna0tXGclY7emzNA= =3n6X -----END PGP SIGNATURE-----