[Cartoweb-users] Edit Plugin - Postgis connection problem

[Oliver Christen]

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 at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>