Paul Ramsey <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]