[postgis-users] Create topologic layers from simple geometries

[Greg Williamson]

Actually --


----- Original Message -----
> From: Mike Toews <mwtoews at gmail.com>
> To: PostGIS Users Discussion <postgis-users at 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 <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

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)