Viva, Pequena correcção para PostgreSQL > 8.3...penso eu.
select row_number() over (order by col1) as id.... ROWNUM penso que é exclusivo ORACLE. Cumps, Fernando Ribeiro No dia 10 de Abril de 2012 19:40, Hugo André Carvalho Poeira < [email protected]> escreveu: > Olá Pedro, > > Faz como é indicado no link que o Giovanni te passou. Na clausula SELECT > acrescenta um campo ROWNUM AS ID, tipo: > > SELECT ROWNUM AS ID, NAME, TIPO FROM A > > O campo ROWNUM vai ser a tua chave primária da view. > > Cumps, > Hugo Poeira > > > > 2012/4/10 Pedro Soares <[email protected]> > >> 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 >> >> > > _______________________________________________ > Portugal mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/portugal > >
_______________________________________________ Portugal mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/portugal
