It Works!
Thank you very much for the help.
Greetings
Pedro Briones García
TRAGSATEC - Gerencia de SIG y Consultoría
________________________________
De: Pedro Mendes [mailto:[email protected]]
Enviado el: viernes, 17 de diciembre de 2010 2:34
Para: Pedro Briones García
CC: [email protected]
Asunto: Re: [Geoserver-users] Oracle View Layer
I tried to make a view with all the information I have. However,
Geoserver does not represent this view: I suppose it's because it generates
repeated records (if the polygon A in the layer has 4 values in the
relationship table, it appears 4 times in the view). However, if the view has
only one record for each polygon, it represents well. If this is the problem,
is it possible to make a view with a column that uniquely identifies all
records in it?
You can incorporate the pseudo-column ROWNUM in your view and then create a
PRIMARY KEY constraint over this column.
Example:
create view INFINITE_VIEW as select rownum as fid, a.geom, b.date from table1
a, table2 b where a.id = b.fk_id;
ALTER VIEW INFINITE_VIEW
ADD CONSTRAINT INFINITE_VIEW_PK
PRIMARY KEY (fid)
DISABLE NOVALIDATE;
Hope this helps.
--
Cumprimentos,
Pedro Mendes
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
