[Qgis-user] Re: postgis layer from a view

[manfredo]

I have sometimes a similar problem with missing unique keys while analyzing
postgis data. 
Example: intersection of 2 polygon geometries using ST_Intersection. 

My workaround: create new table instead of an view like this:

CREATE TABLE mytable WITH OIDS AS
  SELECT  a.name, b.name, ST_Intersection(a.geom, b.geom) AS geom 
  FROM table1 AS a, tabale2 As b
  WHERE ST_IsEmpty(ST_Intersection(a.geom, b.geom)) = FALSE;

Disadvantage: lot of geodata will be created (like in ArcGIS...)

Manfred




--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/postgis-layer-from-a-view-tp5125064p6676049.html
Sent from the qgis-user mailing list archive at Nabble.com.