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

[Mark Cave-Ayland]

Paul Ramsey wrote:

> 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.

In the case of using typmod, views would be interesting; as far as I can 
tell, I think we can just pull the column types (which would include the 
typmod) straight from pg_attribute using the view oid, but it would 
require some more experimentation...


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063