On Mon, Oct 22, 2012 at 08:40:07AM +0200, Pietro Rossin wrote: > DELETE FROM geometry_columns WHERE f_table_name = 'puntigronda'; ... > Is there something wrong?
What's wrong is that the "geometry_columns" table should be a view, in PostGIS-2.0. If it is a view, your DELETE and INSERT and UPDATE to it should have no effect. Can you verify this first ? The DELETE/INSERT/UPDATE commands all return the number of affected rows. If PostGIS is correctly installed you should alwyas get 0, no matter what you try to insert/delete/update. Also check: select relkind from pg_class where relname = 'geometry_columns'; --strk; http://www.cartodb.com - Map, analyze and build applications with your data ~~ http://strk.keybit.net _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
