Jorge, If you don't have the table registered in the geometry_columns table then that would be the problem like the error says. Alternatively you don't need to have it in geometry_columns if you use this syntax DATA "the_geom FROM pai_vec_250 USING UNIQUE gid USING SRID=4326" Where gid has to be a field in your table that uniquely identifies each record. I think Mapserver may put on the additional restriction that the field needs to be an integer, but I've never tried it with a non-integer unique identifier so I could very well be wrong. Hope that helps, Regina
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 8:34 PM To: Postgis-users@postgis.refractions.net Subject: [postgis-users] Need Help with Postgis Hello friends, I try to run a MSW as follows: http://www.sigtruj.org.ve/cgi-sys/mapserv?map=/home/sigtrujo/www /map/prueba1.map&layers=mun_truj&mode=MAP map file, is as follows: MAP NAME mun_t SIZE 400 400 UNITS dd INTERLACE ON EXTENT -74.65 0.64 -56.89 12.19 PROJECTION 'init=EPSG:4189' END FONTSET '../fonts/fonts.txt' SYMBOLSET '../simbolo/simbolo.txt' # Background color for the map canvas -- change as desired IMAGECOLOR 192 192 192 IMAGEQUALITY 95 STATUS on WEB TEMPLATE "../plantilla.html" IMAGEPATH "/home/sigtrujo/www/tmp/ms_tmp/" IMAGEURL "/tmp/ms_tmp/" #EMPTY "http://www.sigtruj.org.ve/plantilla.html"; LOG "../mapservEdenWfsIow.log" METADATA "wms_title" "WMS Demo Server" ##REQUIRED - generates warning in xml output if missing "wms_onlineresourse" "http://localhost/cgi-bin/mapserver.exe"; "wms_srs" "init=epsg:24719" END END #end web LAYER NAME "mun" TYPE POLYGON CONNECTIONTYPE postgis CONNECTION "host=localhost port=5432 user=sigtrujo_test password=andrea08 dbname=sigtrujo_sigtruj" DATA "the_geom FROM pai_vec_250" METADATA "wms_title" "pai_vec_250" END STATUS DEFAULT TRANSPARENCY 45 PROJECTION "init=EPSG:4189" END LABELITEM "nombre" CLASS NAME "pai_vec_250" STYLE SYMBOL 0 OUTLINECOLOR 110 110 110 COLOR 127 143 184 END LABEL SIZE MEDIUM COLOR 64 64 64 OUTLINECOLOR 212 212 212 POSITION CC PARTIALS FALSE FORCE TRUE MINDISTANCE 0 ANGLE 0 BUFFER 4 ENCODING SJIS END END END IMAGETYPE PNG OUTPUTFORMAT NAME PNG DRIVER "GD/PNG" MIMETYPE "image/png" IMAGEMODE PC256 EXTENSION "png" TRANSPARENT ON END END This produces the following error. msDrawMap(): Image handling error. Failed to draw layer named 'mun'. prepare_database(): Query error. Error declaring cursor: ERROR: find_srid() - couldnt find the corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch? With query string: DECLARE mycursor BINARY CURSOR FOR SELECT "nombre"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::tex t from pai_vec_250 WHERE the_geom && setSRID('BOX3D(-74.65 -2.465,-56.89 15.295)'::BOX3D, find_srid('','pai_vec_250','the_geom') ) I can help solve this problem?. thanks Jorge
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
