[maplab-users] PostGis Problem

[Zak James]

Levert,

Are you using the ms4w version of maplab? Are you sure that your
postgres database has been set up with postgis properly? The
"the_geom" stuff is necessary. Maybe you should ask this question on
the mapserver or postgis lists since it's not really related to
maplab.

zak

On 6/9/05, Levert Donovan <dono78fr at yahoo.fr> wrote:
> Hello,
> I would like to convert the tutorial demo, example
> popplace.shp to a sql file for postgis.
> I have convert the file, to popplace.sql
> 
> The postgis database works fine, but, when I want
> insert popplace.sql data, I have this error :
>         ERROR:  couldnt parse objects in GEOMETRY
> 
> 
> This insert request doesn't works
> INSERT INTO "popplace"
> ("area","perimeter","popplace_","popplace_i","unique_key","name","name_e","name_f","unique_key__8","unique_key__9","reg_code","nts50","lat","long","sgc_code","capital","pop_range","the_geom")
> VALUES
> ('0.000','0.000','2','1','AAKDE','Hopedale',NULL,NULL,NULL,NULL,'10','013N08','552800','601300','1010048','0','2','0101000000000000406B423F4100000020B2883341');
> 
> But, if I remove the last column "the_geom", it's
> works fine
> INSERT INTO "popplace"
> ("area","perimeter","popplace_","popplace_i","unique_key","name","name_e","name_f","unique_key__8","unique_key__9","reg_code","nts50","lat","long","sgc_code","capital","pop_range")
> VALUES
> ('0.000','0.000','2','1','AAKDE','Hopedale',NULL,NULL,NULL,NULL,'10','013N08','552800','601300','1010048','0','2');
> 
> 
> 
> Do you know if the column "the_geom" is essential, or
> do know how can I solve this error ?
> 
> Best Regards
> Donovan LEVERT
> 
> 
> 
> 
> 
> 
> _____________________________________________________________________________
> Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos !
> Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
> _______________________________________________
> Maplab-users mailing list
> Maplab-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/maplab-users
> 


-- 
Zak James
Applications and Software Development
DM Solutions Group Inc.
http://www.dmsolutions.ca