[postgis-users] Automatic Geometry_columns

[Paul Ramsey]

We had an interesting thought about a new approach to keeping 
geometry_columns up-to-date.

probe_geometry_columns needs a little work, so upgrade that, rework it 
in C, add support for views and a few other things, so that running it 
is basically a magic refresh of geometry_columns to the current state of 
the data base.

THEN, bind the function into the ANALYZE routine.  Every time ANALYZE 
gets run, update geometry columns.  That way (a) in an autovacuum 
situation (more and more normal) geometry_columns will tend towards 
correctness over time and (b) users can update the table with one small 
command, which is helpful to run anyways.

Paul

-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632