Upper/lower case mismatch for PostGIS layers

[Didrik Pinte]

Le mercredi 11 mai 2005 à 16:51 +0200, Daniel a écrit :
> Hello,
> 
> 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
> (user_ft000001).
> 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 ?

Didrik
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050511/9df9d4f7/attachment.bin