Upper/lower case mismatch for PostGIS layers

[Daniel]

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/attachment.vcf>