[postgis-users] AddGeometryCOlumn error on View

[Piotr Synowiec]

Kevin Neufeld wrote:
> 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.
I have done it
>
> You're right that you will have to manually add or register the view 
> with geometry_columns for some applications to detect the view.
maybe I expressed myself not clearly.
The thing is that AddGeometryColumn function complains that View is not 
a Table and it will not add geometry column to
geometry_columns table

It works after I insert data with INSERT

Just didn't figure it out how to add unique ID field to my VIEW.
The ID I have in my tables merged to the VIEW have repeating IDs

Piotr