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@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 : lcel...@latitude-geosystems.com http://www.latitude-geosystems.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users