[postgis-users] Automatic Geometry_columns

Stephen Woodbridge woodbri at swoodbridge.com
Fri Apr 27 12:18:42 PDT 2007


Paul Ramsey wrote:
> 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
> 
This is a great idea! I really like like it.

-Steve



More information about the postgis-users mailing list