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

[Horst Düster]

To avoid a lot of data trash in your database you can use the PostGIS 
Query Editor Plugin as well.

Regards
Horst

Am 11.08.2011 13:43, schrieb 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.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 

Dr. Horst Düster
Kappasys
Burchacker 6
CH-4556 Aeschi

Tel.: +41(0)62 961 03 74
Mobil: +41(0)76 408 51 06
E-Mail: horst.duester at kappasys.ch
Skype: horstduester
Web: http://www.kappasys.ch


-------------- next part --------------
A non-text attachment was scrubbed...
Name: horst_duester.vcf
Type: text/x-vcard
Size: 260 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110811/d3e2ac38/attachment.vcf>