[postgis-users] Topology : "topology.toTopoGeom" Error message

[celati laurent]

Hello,

I have a error message when i try to use new layer id in populating the 
new topogeometry column :

SELECT topology.CreateTopology('topo_world', 4326);

CREATE TABLE nei_topo(gid serial primary key, id integer, classe_id 
integer, descriptio character varying(80), Labels character varying(24));

SELECT topology.AddTopoGeometryColumn('topo_world', 'public', 
'nei_topo_v2', 'topo', 'MULTIPOLYGON') As new_layer_id;

INSERT INTO nei_topo_v2(gid, id, classe_id, descriptio, labels, topo)
SELECT gid, id, classe_id, descriptio, Labels  topology.toTopoGeom(the_geom, 'topo_world', 3)
FROM land_cover
WHERE gid BETWEEN 1 and 8;


--------------------------------
ERREUR: erreur de syntaxe sur ou près de « . »
LINE 3: ...T gid, id, classe_id, descriptio, Labels topology.toTopoGeo...
^

********** Erreur **********

ERREUR: erreur de syntaxe sur ou près de « . »
État SQL :42601
Caractère : 127

-------------------------------


I send you by attachment : "land_cover" table & "nei-topo_v2" table. For 
information, these 2 tables are in the public schema.

Could you throw light for me please? I don't succeed in populating the 
new topogeometry column.
Could you show me my mistake, can you tell me what I should write 
please? I would like make progress in topology tests...Thank you

Kind regards.


-- 
Laurent Celati – Geospatial applications specialist - LATITUDE GEOSYSTEMS
47, avenue de la Division Leclerc - 95170 Deuil-la-Barre, FRANCE
Tel : + 33 (0)1 34 17 23 84 - Fax : + 33 (0) 1 39 64 04 86
mob : + 33 (0)6 xx xx xx xx
skype lcelati
E-mail : lcelati at latitude-geosystems.com
http://www.latitude-geosystems.com

-------------- next part --------------
A non-text attachment was scrubbed...
Name: land_cover_table.JPG
Type: image/jpeg
Size: 50604 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120629/63e687af/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nei_topo_v2.JPG
Type: image/jpeg
Size: 30855 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120629/63e687af/attachment-0001.jpe>