 	WHERE name='id_valid_status_for_profiles'
 	)
 GROUP BY t.cd_ref;
+
+CREATE UNIQUE INDEX ON gn_profiles.vm_valid_profiles (cd_ref);
 
 CREATE MATERIALIZED VIEW gn_profiles.vm_cor_taxon_phenology AS 
 WITH classified_data AS (

----------------------------------
-- VIEWS AND MATERIALIZED VIEWS --
----------------------------------
CREATE MATERIALIZED VIEW gn_profiles.vm_valid_profiles AS
SELECT DISTINCT
	t.cd_ref AS cd_ref,

LEFT JOIN taxonomie.taxref t ON p.cd_ref=t.cd_ref;


-- Rafraichissement des vues matérialisées des profils
-- USAGE : SELECT gn_profiles.refresh_profiles()
CREATE OR REPLACE FUNCTION gn_profiles.refresh_profiles()
RETURNS VOID AS $$
BEGIN
  REFRESH MATERIALIZED VIEW CONCURRENTLY gn_profiles.vm_valid_profiles;
  REFRESH MATERIALIZED VIEW CONCURRENTLY gn_profiles.vm_cor_taxon_phenology;
END
$$ LANGUAGE plpgsql;

-----------
-- INDEX --
-----------
