<div dir="auto">At least, 4 things can go "wrong" between QGIS and postgis views, which result in the yellow warnings.<div dir="auto"><br></div><div dir="auto">1 - theres no "id" column or it has repeated values; </div><div dir="auto"><br></div><div dir="auto">fix it or create a identifiers on the fly with rownumber() over() as id</div><div dir="auto"><br></div><div dir="auto">2 - QGIS was not able to guess which column to use for unique identifiers;</div><div dir="auto"><br></div><div dir="auto">Call it "id" and make sure it's the first column in the result.</div><div dir="auto"><br></div><div dir="auto">3 - The view returns columns with the same name;</div><div dir="auto"><br></div><div dir="auto">Use alias to change the column names.</div><div dir="auto"><br></div><div dir="auto">SELECT <a href="http://a.id">a.id</a>, <a href="http://a.name">a.name</a>, <a href="http://b.name">b.name</a> as name2 </div><div dir="auto"><br></div><div dir="auto">4 - The view transform the original geometries (for example because you used a function like st_buffer around it) and QGIS does not know what geometry type and SRID to use: cast the geometry columns with expected geometry type. Like this:</div><div dir="auto"><br></div><div dir="auto">st_buffer(geom, 10)::geometry(POLYGON, 3763)</div><div dir="auto"><br></div><div dir="auto">Hope it helps.</div><div dir="auto"><br></div><div dir="auto">Alexandre Neto</div><div dir="auto">QGIS Support</div><div dir="auto"><a href="http://www.qcooperative.net">www.qcooperative.net</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">A quinta, 14/05/2020, 09:14, Andreas Neumann <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<p>Hi Vera,</p>
<p>As far as I know, the yellow triangle means that either something
is wrong with the layer, or that it needs a user input, such as
"choosing a primary key column" in case of a view.</p>
<p>It basically means that the layer can't be loaded, unless the
user provides a hint to QGIS how to correctly load the layer.</p>
<p>I don't think you can configure QGIS to not display these yellow
triangles for views. I also think they are useful indicator to the
users, that they need to do something.<br>
</p>
<p>It could also be a missing SRID, or something else.</p>
<p>Andreas<br>
</p>
<p><br>
</p>
<div>Am 14.05.20 um 09:22 schrieb Vera
Diaz-Köhli:<br>
</div>
<blockquote type="cite">
<div>
<p class="MsoNormal">Hello<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We have made some views in our
PostGIS-Database, so that it is easier for our users to access
the data.<u></u><u></u></p>
<p class="MsoNormal">The views have a column with a unique id (
Y ID).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">In the «Add PostGIS-Layer» dialog, all
those view are listed, with the field «Object-ID» filled in
correctly ( > ID) and they can be added to the map.
However, there’s a little yellow triangle in front of their
names, which only disappears, when I click in the field
«Object-ID».<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">How can I get rid of those yellow
triangles? They are quite confusing for our user, even though
the views do work…<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks in advance<u></u><u></u></p>
<p class="MsoNormal">Vera<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">Qgis-user@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div>