[Qgis-user] Re: postgis layer from a view
manfredo
m.berger at vbd.lu
Thu Aug 11 04:43:35 PDT 2011
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.
More information about the Qgis-user
mailing list