On Fri, Oct 19, 2012 at 02:34:42AM -0700, Pietro Rossin wrote: > > >> INSERT INTO geometry_columns (f_table_catalog,f_table_schema, > >> f_table_name, > >> f_geometry_column, coord_dimension, srid,type) > >> VALUES ('testdb','public', 'pointdata', 'geom', 3, 3004,'POINT'); > > >This shouldn't work, as "geometry_columns" is a view (assuming you > correctly > >installed PostGIS-2.0). > > It works instead.. > I saw that "geometry_columns" is a view but the method works.
Works at doing what ? It probably just silently does nothing. What does this return ? SELECT f_table_name, f_geometry_column, srid, type FROM geometry_columns WHERE f_table_name = 'pointdata'; > The view created is correctly and immediately seen by qgis that loads the > point data. > The only problem is that it takes a year to load it.. That's because QGis scans the whole table since it's unable to find the type and srid information in the geometry_column table. Am I wrong ? --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