You need a PK field for the postGIS Layer, try this:
--view
CREATE VIEW *procedure *AS
SELECT procedure.procedure_id AS *procedure_id*,
procedure.description_url AS procedure_description_url,
procedure.description_type AS procedure_description_type,
feature_of_interest.feature_of_interest_id AS feature_of_interest_id,
feature_of_interest.feature_of_interest_name AS
feature_of_interest_name,
feature_of_interest.feature_of_interest_description AS
feature_of_interest_description,
feature_of_interest.geom AS *geom*,
feature_of_interest.feature_type AS type,
feature_of_interest.schema_link AS schema_link
FROM procedure
LEFT JOIN proc_foi ON procedure.procedure_id = proc_foi.procedure_id
LEFT JOIN feature_of_interest ON proc_foi.feature_of_interest_id =
feature_of_interest.feature_of_interest_id
--mapfile
DATA "*geom *FROM *procedure *USING UNIQUE *procedure_id* USING SRID=4326"
[]'s
--
Marcello Benigno B. de Barros Filho
Prof. do Curso Superior de Tecnologia em Geoprocessamento - IFPB
Mestre em Ciências Geodésicas e Tecnologias da Geoinformação - UFPE
------------------------------------------------------------------------------
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
