[Cartoweb-users] Insert geometry postgis

[Giovanni Virdis]

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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20080530/05e00bc6/attachment.html