Project

General

Profile

« Previous | Next » 

Revision 13923

Added by Aaron Marcuse-Kubitza over 10 years ago

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

View differences:

trunk/schemas/public_.sql
2915 2915 

  		




  2916
  2916
  
    
CREATE FUNCTION source__observation_type(shortname text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS text


  		




  2917
  2917
  
    
    LANGUAGE plpgsql STABLE


  		




  
  2918
  
    
    SET client_min_messages TO 'warning'


  		




  2918
  2919
  
    
    SET search_path TO pg_temp


  		




  2919
  2920
  
    
    AS $$


  		




  2920
  2921
  
    
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  2915
  2915
  
    

  		




  2916
  2916
  
    
CREATE FUNCTION source__observation_type(shortname text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS text


  		




  2917
  2917
  
    
    LANGUAGE plpgsql STABLE


  		




  
  2918
  
    
    SET client_min_messages TO 'warning'


  		




  2918
  2919
  
    
    SET search_path TO pg_temp


  		




  2919
  2920
  
    
    AS $$


  		




  2920
  2921
  
    
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime


  		












Also available in:  Unified diff