-- Name: MatchedTaxon_modify(text); Type: FUNCTION; Schema: TNRS; Owner: -

--

CREATE FUNCTION "MatchedTaxon_modify"(view_query text) RETURNS void

    LANGUAGE sql

    AS $_$

SELECT util.force_recreate($$

-- trigger the dependent_objects_still_exist exception

DROP VIEW "TNRS"."MatchedTaxon"; -- *not* CASCADE; it must trigger an exception

CREATE VIEW "TNRS"."MatchedTaxon" AS 

$$||$1||$$

;

$$||util.mk_set_relation_metadata('"TNRS"."MatchedTaxon"')||$$

-- manually restore views that need to be updated for the changes

-- **IMPORTANT**: keep these updated as described in the views' comments

CREATE VIEW "TNRS"."ValidMatchedTaxon" AS 

 SELECT *

   FROM "TNRS"."MatchedTaxon"

  WHERE "MatchedTaxon".taxon_scrub__is_valid_match;

$$||util.mk_set_relation_metadata('"TNRS"."ValidMatchedTaxon"')||$$

CREATE VIEW "TNRS".taxon_scrub AS 

 SELECT *

   FROM "TNRS"."ValidMatchedTaxon"

   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);

$$||util.mk_set_relation_metadata('"TNRS".taxon_scrub')||$$

$$);

$_$;

--