[postgis-users] Create topologic layers from simple geometries

[celati laurent]

Hello Mike,

I renaming my table "Land_cover" table to "land_cover".

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)
^

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

ERREUR: INSERT a plus de colonnes cibles que d'expressions
État SQL :42601
Caractère : 27


Could you throw light for me?

Regards.




Le 20/06/2012 23:19, Mike Toews a écrit :
> Hi Laurent,
>
> I recommend renaming your "Land_cover" table to "land_cover" (with a
> lower case "l"). It is pretty easy to do with pgAdminIII. Renaming
> your table to lower case will make your queries simpler, since you
> won't need to use double quotes.
>
> Read more about your situation here:
> http://momjian.us/main/blogs/pgblog/2012.html#June_12_2012
>
> -Mike
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
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