[Cartoweb-users] demoEdit question on cartoweb 3.2

[Pierre GIRAUD]

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



-- 
_________________________________________________________
Pierre GIRAUD
Géomaticien, Analyste

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex 

Tel : 00 33 4 79 44 44 93
Mail : pierre.giraud at camptocamp.com
http://www.camptocamp.com