Olá Pedro,<br><br>Faz como é indicado no link que o Giovanni te passou. Na clausula SELECT acrescenta um campo ROWNUM AS ID, tipo:<br><br>SELECT ROWNUM AS ID, NAME, TIPO FROM A<br><br>O campo ROWNUM vai ser a tua chave primária da view.<br>
<br>Cumps,<br>Hugo Poeira<br><br><br><br><div class="gmail_quote">2012/4/10 Pedro Soares <span dir="ltr"><<a href="mailto:pedro_gara@yahoo.com.br">pedro_gara@yahoo.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
olá<div>Criei as queries (das questões de ontem). e fiz três views para representar no QGIS... acontece que qd as tento adicionar no QGIS dá-me o seguinte erro:</div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">
The view 'public.exercise_4' has no column suitable for use as a unique key.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">Qgis requires that the view has a column that can be used as a unique key. Such a column should be derived from a table column of type int4 and be a primary key, have a unique constraint on it, or be a PostgreSQL oid column. To improve performance the column should also be indexed.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">The view you selected has the following columns, none of which satisfy the above conditions:</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">'dfe_code' derives from 'public.estudantes.dfe_code' and is not suitable (type is int4 and does not have a suitable constraint)</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">'geom' derives from 'public.escolas.geom' and is not suitable (type is geometry and does not have a suitable constraint)</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">'name' derives from '<a href="http://public.escolas.name" target="_blank">public.escolas.name</a>' and is not suitable (type is text and does not have a suitable constraint)</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px"><br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px">o que está a faltar será o unique key... existe alguma forma de fazer: Create view blabla with OIDS?</p>
</div>
<br>_______________________________________________<br>
Portugal mailing list<br>
<a href="mailto:Portugal@lists.osgeo.org">Portugal@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/portugal" target="_blank">http://lists.osgeo.org/mailman/listinfo/portugal</a><br>
<br></blockquote></div><br>