[postgis-users] postgis x Mapserver - the fight continues! :-)

[Ednardo Ferreira]

Thanks, any way for everybody. Let's go with my
question.

Anyone told me use mappostis.c from CVS. How I get
him?

Some people is asking same thing but I couldn't yet
solve my problem. Thanks those are helping me.

how were the rounds today:

1- I checked my postgis. It's 0.8.1. 

2- I changed my Mapserver to 4.2.1. It generates the
mapserv file and it's working, but it showed these
messagens (and other similars) hundreds times during
make proccess:

gcc -c -O2  -Wall -DIGNORE_MISSING_DATA  -DUSE_EPPL   
 -DUSE_TIFF -DUSE_JPEG -D USE_GD_PNG -DUSE_GD_JPEG
-DUSE_GD_WBMP -DUSE_GD_FT     -DUSE_POSTGIS   
-I/usr/i nclude          -I/usr/local/pgsql/include   
 shp2img.c -o shp2img.o
gcc -O2  -Wall -DIGNORE_MISSING_DATA  -DUSE_EPPL    
-DUSE_TIFF -DUSE_JPEG -DUSE _GD_PNG -DUSE_GD_JPEG
-DUSE_GD_WBMP -DUSE_GD_FT     -DUSE_POSTGIS   
-I/usr/incl ude          -I/usr/local/pgsql/include   
 shp2img.o  -L. -lmap -lgd -L/usr/lib  -lgd -ljpeg
-lfreetype -lpng -lz    -ltiff -ljpeg -lfreetype -lpng
-lz    -ljpe g    -L/usr/local/pgsql/lib -lpq      -lm
-lstdc++  -o shp2img

3- Without posgis mapserver is working fine, but with
postgis it shows our old friend:

msDrawMap(): Image handling error. Failed to draw
layer named 'states'.
prep_DB(): Query error. Error executing POSTGIS
DECLARE (the actual query) statement: 'DECLARE
mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d()),'NDR'),OID::text
from H�� WHERE && setSRID('BOX3D(-97.5
37.8194380657143,-82.122902 53.1859599342857)'::BOX3D,
find_srid('','H��','') )'

Postgresql reports the error as 'ERROR: relation
"h��" does not exist '

More Help:

Error with POSTGIS data variable. You specified
'<check your .map file>'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using
unique <column name> using SRID=<srid#>'

Make sure you put in the 'using unique <column name>'
and 'using SRID=#' clauses in.

For more help, please see
http://postgis.refractions.net/documentation.php

Mappostgis.c - version of Jan 23/2004.
msPOSTGISLayerParseData(): Query error. Error parsing
POSTGIS data variable. Must contain 'geometry_column
from table_name' or 'geom from (subselect) as foo'
(couldnt find ' from '). More help:

Error with POSTGIS data variable. You specified
'the_geom FROM statesp020'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using
unique <column name> using SRID=<srid#>'

Make sure you put in the 'using unique <column name>'
and 'using SRID=#' clauses in.

For more help, please see
http://postgis.refractions.net/documentation.php

Mappostgis.c - version of Jan 23/2004. 


=====
"Eterno é tudo aquilo que dura uma fração de segundo, mas com tamanha intensidade que se petrifica, e nenhuma força jamais o resgata."

Drummond

__________________________________________________________
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca