[postgis-devel] history management

[strk]

On Thu, Feb 25, 2010 at 03:08:37PM -0300, George Silva wrote:

> About the view: unless the user is building a more complicated view, the
> table is ready for GIS visualization - and this has a evil side: the user
> can edit it. Perhaps it would be wise to publish just a simple view (even
> with a underlying table) and updating the geometry_columns for that view
> only.

By "view" you mean the entry in geometry_columns ?
Have you considered the original table might have multiple geometry
columns (I always do that myself).
In that case your attempt to register one of them won't suffice...

Running populate_geometry_columns() will catch them all (if that's
what the user wants). It's not necessarely what the user wants
as for instance mapserver doesn't need that, nor qgis (that's what
I use...).

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://foo.keybit.net/~strk/services.html