Actually --
----- Original Message ----- > From: Mike Toews <mwto...@gmail.com> > To: PostGIS Users Discussion <postgis-users@postgis.refractions.net> > Cc: > Sent: Thursday, June 28, 2012 2:53 PM > Subject: Re: [postgis-users] Create topologic layers from simple geometries > > On 27 June 2012 23:51, celati laurent <lcel...@latitude-geosystems.com> > wrote: >> Hello Mike, >> I renaming my table "Land_cover" table to "land_cover". > > This fixed the object naming problem; your new issue is not related. > >> I have a new error message : >> INSERT INTO nei_topo(nei, topo) >> SELECT topology.toTopoGeom(the_geom, 'public', 1) >> FROM land_cover >> WHERE gid BETWEEN 1 and 8; >> >> ERREUR: INSERT a plus de colonnes cibles que d'expressions >> LINE 1: INSERT INTO nei_topo(nei, topo) >> Could you throw light for me? > > This is a basic SQL error saying that you want to insert data into two > columns (nei, topo), but you are selecting three columns. Remove the > last one, and it should work. > > -Mike I think the count goes the other way -- insert has two named columns (nei and topo) ... The select has one column -- output from topology.toTopoGeom Provide a value for nei (gid? some other value?) or remove it from the insert and let it default to whatever the nei_topo table says. HTH, Greg W. (not familiar w/ the topology tools so I hope I am not off base) _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users