[postgis-devel] Re: [postgis-users] create tables smarter

[Paul Ramsey]

On Thu, Jun 5, 2008 at 6:32 AM, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
> The only problem with analyze is I fail to see how this helps with
> views.  The main PITA I have with the geometry_columns thing is that I
> have to manually register my views or as Kevin says - write some hack to
> query the system tables to derive the SRID of my views.

I'd propose the utility process by basically a side effect of ANALYZE
and clean up everything about GEOMETRY_COLUMNS. Remove dead entries,
find new ones, etc, rather than just restricting itself to the one
table it was (potentially) called on.

P.