Paul Ramsey <pramsey@refractions.net> writes:
> We have a similar requirement for PostGIS.
> In order to meet the OpenGIS specification, we have to maintain a
> GEOMETRY_COLUMNS table which includes an entry for every column in the
> db which holds a spatial column. It would be ideal if we could have
> triggers run on CREATE TABLE, DROP TABLE, and ALTER TABLE to watch for
> the comings and goings of spatial columns and update GEOMETRY_COLUMNS
> appropriately.
Couldn't you define GEOMETRY_COLUMNS as a view? Seems a lot more
efficient than firing random triggers on every table operation.
regards, tom lane