olá 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:
The view 'public.exercise_4' has no column suitable for use as a unique key. 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. The view you selected has the following columns, none of which satisfy the above conditions: 'dfe_code' derives from 'public.estudantes.dfe_code' and is not suitable (type is int4 and does not have a suitable constraint) 'geom' derives from 'public.escolas.geom' and is not suitable (type is geometry and does not have a suitable constraint) 'name' derives from 'public.escolas.name' and is not suitable (type is text and does not have a suitable constraint) o que está a faltar será o unique key... existe alguma forma de fazer: Create view blabla with OIDS?
_______________________________________________ Portugal mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/portugal
