[postgis-users] AddGeometryCOlumn error on View

[Kevin Neufeld]

Piotr Synowiec wrote:
  > Is there any particular reason why AddGeoemtryColumn doesn't work on
> Views ?
> 

AddGeometryColumn adds a column to a table and registers the column with the geometry_columns.  If you want to add a 
geometry column to your VIEW, alter your VIEW to select the column from an appropriate underlying table.

You're right that you will have to manually add or register the view with geometry_columns for some applications to 
detect the view.

-- Kevin