[postgis-users] How to make some geometry column visible to Qgis

[Sandro Santilli]

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