Hi
I have implements the solution to edit the geometry with postgis but I
have the problem.
This is the layer configuration in map file
LAYER
NAME FABRIZIO
STATUS ON
TYPE POLYGON
CONNECTIONTYPE POSTGIS
CONNECTION 'dbname=Iwork_topo user=Iwork_topo password=colapasta
host=10.0.0.3'
DATA '"G" from (select "G", "A" from "AAA1") as foo using unique
"A" using srid=-1'
TEMPLATE 'ttt'
TRANSPARENCY 50
LABELITEM "A"
CLASS
NAME "class"
STYLE
COLOR 50 50 255
OUTLINECOLOR 255 50 50
END
LABEL
TYPE TRUETYPE
FONT "Vera"
SIZE 7
COLOR 0 0 0
POSITION cc
BACKGROUNDCOLOR 245 235 235
BACKGROUNDSHADOWCOLOR 55 55 55
BACKGROUNDSHADOWSIZE 1 1
END
END
LABELMAXSCALE 50000
METADATA
'id_attribute_string' 'A' # query
'query_returned_attributes' 'A'
'edit_table' 'AAA1' # PostGIS table
'edit_geometry_column' 'G' # PostGIS geometry column
'edit_geometry_type' 'polygon' # PostGIS geometry type
'edit_srid' '-1'
'edit_attributes' 'A|integer' # list of the editable fields
'edit_filter' '' # mapserver filter
END
END
When I draw the polygon and insert the value for the filed A the system
generate this error:
Class : SoapFaultWrapper
Message : Unable to insert feature in edit database Message: DB Error:
unknown error Userinfo: INSERT INTO public.AAA1 (G , A) VALUES
(GeometryFromText('MULTIPOLYGON(((1522314.4719729544
4518388,1518017.9437111818 4498500,1525706.467969091
4496918,1531812.0607621362 4505958,1531585.9276957272
4516354,1522314.4719729544 4518388)))', -1) , '11') [nativecode=ERROR:
la relazione "public.aaa1" non esiste]
Backtrace:
I have the problem with the " .
The insert for postegre must be in this format INSERT INTO "public.AAA1"
("G ", "A")
How I can do?
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
