Upper/lower case mismatch for PostGIS layers

Daniel daniel.faivre at CAMPTOCAMP.COM
Wed May 11 11:16:23 EDT 2005


Didrik Pinte wrote:

>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
>
>
Yes: it result in a crash ...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: daniel.faivre.vcf
Type: text/x-vcard
Size: 382 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050511/ebfc2af1/daniel.faivre.vcf


More information about the mapserver-users mailing list