Upper/lower case mismatch for PostGIS layers
dpinte at ITAE.BE
Wed May 11 10:56:38 EDT 2005
Le mercredi 11 mai 2005 à 16:51 +0200, Daniel a écrit :
> I encounter a problem with a PostGIS layer defined with:
> DATA "geom from user_FT000001.annuaire"
> Mapserver send the request to PostGIS with the schema name in lowercase
> But I need to have it in uppercase to comply with the externally defined
> database structure ...
> Is there a way to have this working without writing a full "select from"
> clause ?
> Daniel FAIVRE
Under postgresql, to have uppercase table or field names, you need to
quote them ...
Did you test it quoting the schema name ?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050511/9df9d4f7/attachment.bin
More information about the mapserver-users