[Qgis-user] postgis layer from a view
Bernhard Ströbl
Bernhard.Stroebl at jena.de
Tue Jun 1 02:05:19 PDT 2010
Dear Lionel,
AFAIK the view must contain a field being defined as primary key in the
underlying table, moreover this field must be of type integer.
The view must be defined in a way that every element (thus every
primary-key value) is unique. In case the view contains a join resulting
in several primary-key fields you can choose which one QGIS should use.
So your view definition lacks the primary-key field, although the
sequence - of course - populates gid with unique values.
Maybe you could post the complete view definition (and the table
definitions, too) and we could see if we could help you in creating a
working view.
regards
Benno
Lionel Roubeyrie schrieb:
> Hi all,
> I can't load datas from a postgis view, the loader complains about no
> uniques values and int4 type, however the view starts with "SELECT
> nextval('my_seq'::regclass)::integer AS gid, com.the_geom, ..." (the
> gid column is not listed in the error message) which works perfectly
> if datas are stored in a table. Is there a trick to load datas from
> views, and more generally is it possible to force the postgis provider
> to create an internal unique key?
> Thanks
>
________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Server.
http://www.nod32.com
More information about the Qgis-user
mailing list