Project

General

Profile

« Previous | Next » 

Revision 13518

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: MatchedTaxon_modify(): removed no longer needed DROP VIEW statement

View differences:

trunk/inputs/.TNRS/schema.sql
47 47 
    LANGUAGE sql
48 48 
    AS $_$
49 49 
SELECT util.recreate($$
50 
-- trigger the dependent_objects_still_exist exception
51 
DROP VIEW "TNRS"."MatchedTaxon"; -- *not* CASCADE; it must trigger an exception
52 

  		




  53
  50
  
    
CREATE VIEW "TNRS"."MatchedTaxon" AS 


  		




  54
  51
  
    
$$||$1||$$


  		




  55
  52
  
    
;


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  16811
  16811
  
    
    LANGUAGE sql


  		




  16812
  16812
  
    
    AS $_$


  		




  16813
  16813
  
    
SELECT util.recreate($$


  		




  16814
  
  
    
-- trigger the dependent_objects_still_exist exception


  		




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


  		




  16816
  
  
    

  		




  16817
  16814
  
    
CREATE VIEW "TNRS"."MatchedTaxon" AS 


  		




  16818
  16815
  
    
$$||$1||$$


  		




  16819
  16816
  
    
;


  		












Also available in:  Unified diff