PostGIS case problem

[Armin Burger]

This is a general strange Postgres hehaviour: if a column has upper case characters (no matter at which place) it has to be put in double quotes in the query. I therefore always avoid upper case charcaters for columns in PG. 

In Mapserver you could try 

DATA '"Geometrija" FROM Objekti_Uprave'

like this, Postgres should in principal get the correct SQL string.

armin


--------  Re: [UMN_MAPSERVER-USERS] PostGIS case problem

> Sebastian Walter wrote:
> > Hi Daniel,
> > 
> > 
> > 
> > According to my map file, I would use
> > 
> > DATA "Geometrija FROM Objekti_Uprave"
> > 
> > (without single quotes, double quotes around the whole expression).
> Perhaps this will work for you also... 
> > 
> > Probably postgres will have trouble with the underscore (_). In this
> case, try to rename the table...
> > 
> > 
> 
> 	Nope, it will not help. I have tried following. I have create
> new table in lower case and it worked, but if just one attribute is
> renamed with firt capital letter then mapserver gives me empty WFS
> reply (only BBox). There is definitely some problem with mapserver and
> postgis.
> 
> 					Best regards,
> 					Daniel Vencler

-- 


Echte DSL-Flatrate dauerhaft für 0,- Euro*. Nur noch kurze Zeit!
"Feel free" mit GMX DSL: http://www.gmx.net/de/go/dsl