It looks like you need to quote "Land_cover" in the INSERT statement.
PS: please copy & paste the queries and error messages inline as text, it's easier to read than screenshots. --strk; Sent from our free software http://www.gnu.org/philosophy/free-sw.html On Wed, Jun 20, 2012 at 11:17:04AM +0200, lcel...@latitude-geosystems.com wrote: > Hello, > > Regarding a big project in Cameroon, i'm testing topology in Postgis. I > have created a db called "Test_Cameroun". I have already import simple > geometries into two tables called "land cover" (MULTYPOLYGONN) and > "network"(MULTILINES). > These two tables are localised into public schema. > I want to create topologic layers from these simple geometries. I have > created a new topology schema (create topology) called "topology_test" > successfully. > Then, I read the example written on toTopoGeom postgis page: > > http://postgis.refractions.net/documentation/manual-2.0/toTopoGeom.html > > That's why i have created a new table called for instance "nei_topo" > always in public schema : > > CREATE TABLE nei_topo(gid serial primary key, nei varchar(30)); > > Then, > > I added to it a topogeometry column > > SELECT topology.AddTopoGeometryColumn('topology_test', 'public', > 'nei_topo', 'topo', 'MULTIPOLYGON') As new_layer_id; > > > Then,I want to populating the new topogeometry column via use new layer id. > > INSERT INTO nei_topo(nei, topo) > SELECT nei, topology.toTopoGeom(geom, 'topo_cameroun', 1) > FROM Land_cover > WHERE gid BETWEEN 1 and 8; > > But i have a error message. > > I send you by attachment all screen shots. > > Could you throw light for me ASAP please. > Kind regards. > > Laurent Celati. > > > > > -- > 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 : lcel...@latitude-geosystems.com > http://www.latitude-geosystems.com > > > > ----- Fin du message transféré ----- > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users