Project

General

Profile

« Previous | Next » 

Revision 13607

inputs/.TNRS/schema.sql: *_modify(): allow running without a view_query, as recreate_view() now supports this

View differences:

vegbien.sql
16835 16835
-- Name: MatchedTaxon_modify(text); Type: FUNCTION; Schema: TNRS; Owner: -
16836 16836
--
16837 16837

  
16838
CREATE FUNCTION "MatchedTaxon_modify"(view_query text) RETURNS void
16838
CREATE FUNCTION "MatchedTaxon_modify"(view_query text DEFAULT NULL::text) RETURNS void
16839 16839
    LANGUAGE sql
16840 16840
    AS $_$
16841 16841
SELECT util.recreate_view('"TNRS"."MatchedTaxon"', $1, $$
......
16926 16926
-- Name: taxon_scrub_modify(text); Type: FUNCTION; Schema: TNRS; Owner: -
16927 16927
--
16928 16928

  
16929
CREATE FUNCTION taxon_scrub_modify(view_query text) RETURNS void
16929
CREATE FUNCTION taxon_scrub_modify(view_query text DEFAULT NULL::text) RETURNS void
16930 16930
    LANGUAGE sql
16931 16931
    AS $_$
16932 16932
SELECT util.recreate_view('"TNRS".taxon_scrub', $1);

Also available in: Unified diff