-- use `*, ... AS accepted_morphospecies_binomial` as the column list

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 

SELECT *, ... AS accepted_morphospecies_binomial

/*revised def*/

;

GRANT SELECT ON TABLE "TNRS"."MatchedTaxon" TO bien_read;

COMMENT ON VIEW "TNRS"."MatchedTaxon"

  IS ''

...

'';

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

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

CREATE VIEW "TNRS"."ValidMatchedTaxon" AS 

 SELECT *

   FROM "TNRS"."MatchedTaxon"

  WHERE "MatchedTaxon".taxon_scrub__is_valid_match;

GRANT SELECT ON TABLE "TNRS"."ValidMatchedTaxon" TO bien_read;

COMMENT ON VIEW "TNRS"."ValidMatchedTaxon"

  IS ''

to update, use * as the column list

'';

CREATE VIEW "TNRS".taxon_scrub AS 

 SELECT *

   FROM "TNRS"."ValidMatchedTaxon"

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

GRANT SELECT ON TABLE "TNRS".taxon_scrub TO bien_read;

COMMENT ON VIEW "TNRS".taxon_scrub

  IS ''

to update, use * as the column list

'';