[postgis-users] Create topologic layers from simple geometries

[Mike Toews]

On 27 June 2012 23:51, celati laurent <lcelati at 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