[Mapserver-users] Accessing uppercase tables with a PostGIS connection
jmckenna at dmsolutions.ca
Fri May 14 15:36:39 EDT 2004
yes i wrote that wrong..i meant a column name, sorry. The column name
is ""CST00SRF" . I want to avoid having to reload all of the data (with
the LAUNDER option). Is that my only option?
Tyler Mitchell wrote:
>>I'm just a little confused again ha. I seem to want to do something
>>so simple yet I'm
>>stuck again. My PostGIS DB has a table named "CST00SRF", and I
>>simply want to specify
>>that as the CLASSITEM column in my mapfile. I get this returned
>>when i load the page:
>>Postgresql reports the error as 'ERROR: column "cst00srf" does not exist
> Hmm...you are trying to reference a COLUMN and not a TABLE for your
> CLASSITEM right?
> In your note you mentioned "a table named "CST00SRF" " - is that really a
> column? Is the error report actually correct and you are getting confused
> by putting a table name in place of where a colum name should be?
> Otherwise, can you reload your PostGIS data? With ogr2ogr there is a
> creation option "-lco LAUNDER=YES" that will clean up you object names.
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
DM Solutions Group Inc.
More information about the mapserver-users