   COST 100;
 
 
--- suppression d'un relevé
+-- Suppression d'un relevé
 CREATE OR REPLACE FUNCTION fct_tri_synthese_delete_releve()
 RETURNS trigger AS
 $BODY$

    ADD CONSTRAINT pk_pr_occtax_defaults_nomenclatures_value PRIMARY KEY (mnemonique_type, id_organism, regne, group2_inpn);


---------------
--FOREIGN KEY--
---------------
ALTER TABLE ONLY t_releves_occtax
    ADD CONSTRAINT fk_t_releves_occtax_t_datasets FOREIGN KEY (id_dataset) REFERENCES gn_meta.t_datasets(id_dataset) ON UPDATE CASCADE;


------------
--TRIGGERS--
------------

CREATE TRIGGER tri_insert_default_validation_status
  AFTER INSERT
  ON cor_counting_occtax
