Project

General

Profile

« Previous | Next » 

Revision 13527

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: MatchedTaxon_modify(): use simpler util.recreate_view()

View differences:

trunk/inputs/.TNRS/schema.sql
46 46 
CREATE FUNCTION "MatchedTaxon_modify"(view_query text) RETURNS void
47 47 
    LANGUAGE sql
48 48 
    AS $_$
49 
SELECT util.recreate($$
50 
CREATE VIEW "TNRS"."MatchedTaxon" AS
51 
$$||$1||$$
52 
;
53 
$$||util.mk_set_relation_metadata('"TNRS"."MatchedTaxon"')||$$
54 

  		




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


  		




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


  		




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


  		




  57
  51
  
    

  		




  58
  52
  
    
CREATE VIEW "TNRS"."ValidMatchedTaxon" AS 


  		












  

    
      trunk/schemas/vegbien.sql
    
  





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


  		




  16811
  16811
  
    
    LANGUAGE sql


  		




  16812
  16812
  
    
    AS $_$


  		




  16813
  
  
    
SELECT util.recreate($$


  		




  16814
  
  
    
CREATE VIEW "TNRS"."MatchedTaxon" AS 


  		




  16815
  
  
    
$$||$1||$$


  		




  16816
  
  
    
;


  		




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


  		




  16818
  
  
    

  		




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


  		




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


  		




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


  		




  16821
  16815
  
    

  		




  16822
  16816
  
    
CREATE VIEW "TNRS"."ValidMatchedTaxon" AS 


  		












Also available in:  Unified diff