Project

General

Profile

« Previous | Next » 

Revision 13922

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: in_iucn_red_list(): don't display NOTICEs about the search_path, because this function will be called millions of times

View differences:

trunk/schemas/public_.sql
2187 2187 

  		




  2188
  2188
  
    
CREATE FUNCTION in_iucn_red_list(accepted_family text, accepted_species_binomial text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS boolean


  		




  2189
  2189
  
    
    LANGUAGE plpgsql STABLE


  		




  
  2190
  
    
    SET client_min_messages TO 'warning'


  		




  2190
  2191
  
    
    SET search_path TO pg_temp


  		




  2191
  2192
  
    
    AS $$


  		




  2192
  2193
  
    
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  2187
  2187
  
    

  		




  2188
  2188
  
    
CREATE FUNCTION in_iucn_red_list(accepted_family text, accepted_species_binomial text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS boolean


  		




  2189
  2189
  
    
    LANGUAGE plpgsql STABLE


  		




  
  2190
  
    
    SET client_min_messages TO 'warning'


  		




  2190
  2191
  
    
    SET search_path TO pg_temp


  		




  2191
  2192
  
    
    AS $$


  		




  2192
  2193
  
    
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime


  		












Also available in:  Unified diff