populate_geometry_columns: ERROR: cannot alter type of a column used in a trigger definition

[strk]

This is the situation: I've a table with a column of type "geometry" which is used in a trigger. There is no constraint on the type of the geometry, but all rows are of type POINT and srid 4326.

I think in normal situation populate_geometry_column() would alter the table to become of type "geometry(point, 4326)" but in this case it would fail with this message:

ERROR:  cannot alter type of a column used in a trigger definition

I think it should be fixed in 2.0 by disabling the trigger during the ALTER as we know we're not really altering the value of the geometry but only it's _advertised_ type, right ?

[strk]

NOTE: using constraints is not a problem

[strk]

The only thing we could do is:

0. Fetch trigger definition
1. DROP the trigger
2. Run the ALTER TABLE
3. CREATE the trigger

[strk]

A close friend of the trigger one:

ERROR:  cannot alter type of a column used by a view or rule

[strk]

I think it would be good to only skip the problematic tables rather than throw away the whole transaction, and the code seems to partially do that, but only when the exception thrown is "invalid_parameter_value"

[robe]

We aren't goind to be fiddling with views or triggers. And I'm not going to changing this function in a week to raise a warning.