Project

General

Profile

« Previous | Next » 

Revision 13607

Added by Aaron Marcuse-Kubitza over 10 years ago

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

View differences:

trunk/inputs/.TNRS/schema.sql
45 45 
-- Name: MatchedTaxon_modify(text); Type: FUNCTION; Schema: TNRS; Owner: -
46 46 
--
47 47 

  		




  48
  
  
    
CREATE FUNCTION "MatchedTaxon_modify"(view_query text) RETURNS void


  		




  
  48
  
    
CREATE FUNCTION "MatchedTaxon_modify"(view_query text DEFAULT NULL::text) RETURNS void


  		




  49
  49
  
    
    LANGUAGE sql


  		




  50
  50
  
    
    AS $_$


  		




  51
  51
  
    
SELECT util.recreate_view('"TNRS"."MatchedTaxon"', $1, $$


  		




  ......




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


  		




  137
  137
  
    
--


  		




  138
  138
  
    

  		




  139
  
  
    
CREATE FUNCTION taxon_scrub_modify(view_query text) RETURNS void


  		




  
  139
  
    
CREATE FUNCTION taxon_scrub_modify(view_query text DEFAULT NULL::text) RETURNS void


  		




  140
  140
  
    
    LANGUAGE sql


  		




  141
  141
  
    
    AS $_$


  		




  142
  142
  
    
SELECT util.recreate_view('"TNRS".taxon_scrub', $1);


  		












  

    
      trunk/schemas/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