-----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: [EMAIL PROTECTED] > US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > 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----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
