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

[strk at refractions.net]

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;