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

[strk at refractions.net]

On Thu, May 12, 2005 at 12:02:07PM +0200, Daniel wrote:
> 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 !

I posted a patch about 3 years ago for mapserver support of 
MiXeD case identifiers... I'm off now ;)
Send a mail to mapserver developers.

--strk;

> 
> dF
> 
> 


> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users