[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Adding view to geometry_columns table
From:       Milo van der Linden <mlinden () zeelandnet ! nl>
Date:       2008-03-21 8:18:47
Message-ID: 47E36F67.70507 () zeelandnet ! nl
[Download RAW message or body]

Hello Lee,

There are no pitfalls, working with views in the geometry_columns is the 
way to do it. It doesn't matter what non geometry columns you change, as 
long as you leave the geometry column in place.
The only thing is that when you want to use QuantumGIS to have edit 
access you need to do it on the table directly, not on the view.

Lee Hachadoorian schreef:
> Is there any problem, or is it common, to add a view to the
> geometry_columns table?  I'm experimenting using zigGIS to add PostGIS
> layers to an ArcGIS 9.2 project.  It seems that zigGIS only "sees"
> tables listed in geometry_columns (unlike Quantum GIS which "sees"
> anything with a geometry column, including views based on tables with
> geometry columns).  So I manually added a row to geometry_columns with
> the names of the schema, view (in column f_table_name) and geometry
> column.  Seems to be working fine, and this way I can easily add or
> drop attributes from the layer, or join data from several different
> tables.  Are there are any pitfalls I should be aware of?
>
> Thanks,
> Lee Hachadoorian
> PhD Student, Geography
> Program in Earth & Environmental Sciences
> CUNY Graduate Center
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]