Project

General

Profile

« Previous | Next » 

Revision 13496

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/util.sql: explain(): don't display any log messages printed by IMMUTABLE functions in the query, which EXPLAIN apparently runs

View differences:

util.sql
1675 1675 

  		




  1676
  1676
  
    
CREATE FUNCTION explain(sql text) RETURNS SETOF text


  		




  1677
  1677
  
    
    LANGUAGE sql


  		




  
  1678
  
    
    SET client_min_messages TO 'error'


  		




  1678
  1679
  
    
    AS $_$


  		




  
  1680
  
    
/* `client_min_messages = ERROR`: EXPLAIN apparently runs IMMUTABLE functions in


  		




  
  1681
  
    
the query, so this prevents displaying any log messages printed by them */


  		




  1679
  1682
  
    
SELECT util.eval2set($$EXPLAIN $$||$1, verbose_ := false)


  		




  1680
  1683
  
    
$_$;


  		




  1681
  1684
  
    

  		












Also available in:  Unified diff