since you have gid and not oid, you need to add a "USING gid" at the
connection string.
see the postgis tutorial
http://www.mapbender.org/presentations/Spatial_Data_Management_Arnulf_Christl/Spatial_Data_Management_Arnulf_Christl.pdf
page 20 and after
regards
Oliver
Hello again!
I set the connection parameters exactly as in the demoEdit.map file.
But still i get the following error message:
CartoWeb version: 3.4.0 [$Revision: 1.7 $]
class: SoapFaultWrapper
message: MapServer error: Error in msDrawMap(): Failed to draw layer
named 'bank_store'.
Error in prepare_database(): Error executing POSTGIS DECLARE (the actual
query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
(select the_geom,label from volos) as foo WHERE the_geom &&
setSRID('BOX3D(22.865 39.3060837563439,23 39.4005161436561)'::BOX3D,
find_srid('','volos','the_geom') )'
Postgresql reports the error as 'ERROR: column "oid" does not exist
LINE 1: ...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ...
I have mapserver version 5.0.2
and a postgis database with a table named 'volos'.
The table has 7 columns which are created with the following script (taken
from pgAdmin)
gid serial NOT NULL,
v_poi_ integer,
v_poi_id integer,
city character varying(30),
city_lat character varying(30),
label character varying(70),
the_geom geometry
Finaly,this is the layer part that deals with the database connection.
I hope i have written all necessary information.
Thank you!!!
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
