[Qgis-user] How to load postgis layer without gid (if possible..)?

[Bernhard Ströbl]

Hi Pietro,

what I do in similar cases (creating Views, not sure if it works with 
SQL layer) is:
SELECT min(my_pk_column), ST_Union(ST_Buffer(geom,500) as geom FROM 
public.mytable

Bernhard

Am 07.11.2012 08:38, schrieb Pietro Rossin:
> Hi all
>
> I tried to load in Qgis, by using fast SQL layer, a query like this:
>
> SELECT (select ST_Union(ST_Buffer(geom,500)) FROM public.mytable) as geom;
>
> This query make a buffer of the features in mytable and union them in a
> single polygon (if contiguous).
>
> It works in pgadmin and in openjump but not in Qgis, because Qgis need a
> unique value (integer) column coming from the query.
>
> Of course I can make a SELECT INTO mynewtable adding a serial field "gid",
> but if I have a lot of steps to perform my spatial analysis I fill my db
> with a lot of temp data.
>
> So, is there some way to make a "volatile" integer unique field in the above
> query so Qgis will be happy with it ;-)?
>
> I'm using Qgis 1.8 Postgis 2
>
> Thanks
> Pietro
>
>
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/How-to-load-postgis-layer-without-gid-if-possible-tp5014459.html
> Sent from the Quantum GIS - 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
>
>
> __________ Information from ESET Mail Security, version of virus signature database 7666 (20121106) __________
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
>

-- 
Bernhard Ströbl
Anwendungsbetreuer GIS

Kommunale Immobilien Jena
Am Anger 26
07743 Jena

Tel.: 03641 49- 5190
E-Mail: bernhard.stroebl at jena.de
Internet: www.kij.de


Kommunale Immobilien Jena
Eigenbetrieb der Stadt Jena
Werkleiter: Dr. Götz Blankenburg


__________ Information from ESET Mail Security, version of virus signature database 7666 (20121106) __________

The message was checked by ESET Mail Security.
http://www.eset.com