[Cartoweb-users] demoEdit question on cartoweb 3.2

[tom at bouillut.org]

the demoEdit failed to add a linestring while using MULTILINESTRING in 
table constraint
it works fine with LINESTRING constraint
is there a way to force a multilinestring query in edition mode ?
tom bouillut
tom at bouillut.org a écrit :

> thanx , error fixed :)
> tom bouillut
> Pierre GIRAUD a écrit :
>
>> Have a try with the following (sentiers_id_seq modified to 
>> sentiers_gid_seq) :
>>
>> CREATE TABLE "sentiers" (gid serial PRIMARY KEY,
>> "nom" text,
>> "url" text,
>> "author" text,
>> "created" timestamp without time zone,
>> "modified" timestamp without time zone) WITH OIDS;
>> ALTER TABLE sentiers OWNER TO postgres;
>> GRANT ALL ON TABLE sentiers TO postgres WITH GRANT OPTION;
>> GRANT ALL ON TABLE sentiers_gid_seq TO postgres WITH GRANT OPTION;
>> GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE sentiers TO "www-data";
>> GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE sentiers_id_seq TO 
>> "www-data";
>> SELECT 
>> AddGeometryColumn('','sentiers','the_geom','-1','MULTILINESTRING',2);
>> GRANT ALL ON TABLE geometry_columns TO postgres WITH GRANT OPTION;
>> GRANT SELECT ON TABLE geometry_columns TO "www-data";
>>
>> Regards
>>
>> Pierre
>>
>> tom at bouillut.org wrote:
>>
>>> hi ,
>>> while creating a line layer table for use with the demoEdit project 
>>> i got an error
>>>
>>> here is my table creation script for sentiers layer creation
>>>
>>> CREATE TABLE "sentiers" (gid serial PRIMARY KEY,
>>> "nom" text,
>>> "url" text,
>>> "author" text,
>>> "created" timestamp without time zone,
>>> "modified" timestamp without time zone) WITH OIDS;
>>> ALTER TABLE sentiers OWNER TO postgres;
>>> GRANT ALL ON TABLE sentiers TO postgres WITH GRANT OPTION;
>>> GRANT ALL ON TABLE sentiers_id_seq TO postgres WITH GRANT OPTION;
>>> GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE sentiers TO "www-data";
>>> GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE sentiers_id_seq TO 
>>> "www-data";
>>> SELECT 
>>> AddGeometryColumn('','sentiers','the_geom','-1','MULTILINESTRING',2);
>>> GRANT ALL ON TABLE geometry_columns TO postgres WITH GRANT OPTION;
>>> GRANT SELECT ON TABLE geometry_columns TO "www-data";
>>>
>>> ---
>>>
>>> postgres at alibalo:/home/tom/calquev2/activitees_humaine/infrastructures/randonnee$ 
>>> psql sigfreed_cw3 < sentiers.sql
>>> BEGIN
>>> NOTICE:  CREATE TABLE will create implicit sequence 
>>> "sentiers_gid_seq" for serial column "sentiers.gid"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
>>> "sentiers_pkey" for table "sentiers"
>>> CREATE TABLE
>>> ALTER TABLE
>>> GRANT
>>> ERROR:  relation "sentiers_id_seq" does not exist
>>> ERROR:  current transaction is aborted, commands ignored until end 
>>> of transaction block
>>>
>>> as i have done almost the same query to create a point layer without 
>>> any trouble , can you give me any advice to solve this ?
>>>
>>>
>>> tom bouillut
>>>
>>>
>>> _______________________________________________
>>> Cartoweb-users mailing list
>>> Cartoweb-users at lists.maptools.org
>>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>
>>
>>
>>
>>
>
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>