[postgis-users] Geometry_columns of a view

[manuel escobar ubreva]

Hello! I have a doubt. I created the view with geometry, with  the next sql:

CREATE VIEW Z AS
 SELECT a.id........, c.the_geom
 FROM actgis a
 JOIN Parc2009 c ON a.ref_catastral= c.refcat;

I can´t include the record into the geometry columns of generated vew. Do
you have some advices?

What can I do to renew geometry_columns with the information from the new
view?Can I use  the addgeometry_columns functions or I should modify
it,because it's functiones can only be used for the table?

thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120720/f27dc5a2/attachment.html>