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
