[postgis-users] Upper/lower case mismatch with postgis layers in mapserver

[Daniel]

strk at refractions.net wrote:

>On Thu, May 12, 2005 at 11:29:10AM +0200, Daniel wrote:
>  
>
>>Hello,
>>
>>I encounter a problem with a PostGIS layer defined for mapserver 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 ?
>>
>>Nota:
>>1) I've tried to quote the schema name -> crash
>>2) I've posted this on the mapserver list before ...
>>
>>Daniel FAIVRE
>>    
>>
>
>Does this crash ?
> 
>DATA 'geom from "user_FT000001"."annuaire"'
>
>--strk;
>
>
>  
>
yes:

Postgresql reports the error as 'ERROR:  schema "user_ft000001" does not exist

(it's true: the schema name is user_FT000001)

Any idea ?

Thanks !

dF


-------------- 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/postgis-users/attachments/20050512/41d36572/attachment.vcf>