[postgis-devel] Re: [postgis-users] usage of AddGeometryColumn etc.

[David Blasby]

strk wrote:

> Again, triggers on system tables are not seen with simpaty.
> If you guys write down every occurrence of the stale record problem
> we can find out an ad-hoc solution (like adding check in AddGeometryColumn
> which I think is the one function making noise about it).
> 
> --strk;
> 
> PS: I've just committed changes in the postgis.sql.in file to make
>     find_extent and build_histogram2d (and update_geometry_stats)
>      better support schema in the way you suggested.

One way would be to make a geometry_columns_meta table with all the 
information in it (like we have now).  Then have geometry_columns be a 
view that crosses the system table with the geometry_columns_meta table. 
  This will hide any "stale" rows.

Alternately, you could have AddGeometryColumn() behave smarter - it 
should automagically delete any stale columns in the current 
geometry_columns table (or the future geometry_columns_meta table).

dave