[Mapserver-users] Accessing uppercase tables with a PostGIS connection

[Jeff McKenna]

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?

thanks.

jeff




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.
> 
> Tyler
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 


-- 
Jeff McKenna
GIS Specialist
DM Solutions Group Inc.
http://www.dmsolutions.ca