[postgis-users] Automatic Geometry_columns

[Bruce Rindahl]

I like this too.  probe_geometry_columns is a great tool and I don't even
think it is the documentation.
Bruce

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stephen
Woodbridge
Sent: Friday, April 27, 2007 1:19 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Automatic Geometry_columns

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users