Project

General

Profile

« Previous | Next » 

Revision 12668

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/util.sql: added debug_print_func_call(text) and use it where applicable

View differences:

trunk/schemas/util.sql
991 991 

  		




  992
  992
  
    

  		




  993
  993
  
    
--


  		




  
  994
  
    
-- Name: debug_print_func_call(text); Type: FUNCTION; Schema: util; Owner: -


  		




  
  995
  
    
--


  		




  
  996
  
    

  		




  
  997
  
    
CREATE FUNCTION debug_print_func_call(func_call text) RETURNS void


  		




  
  998
  
    
    LANGUAGE sql IMMUTABLE


  		




  
  999
  
    
    AS $_$


  		




  
  1000
  
    
SELECT util.raise('NOTICE', $$SELECT $$||$1)


  		




  
  1001
  
    
$_$;


  		




  
  1002
  
    

  		




  
  1003
  
    

  		




  
  1004
  
    
--


  		




  994
  1005
  
    
-- Name: debug_print_return_value(anyelement, boolean); Type: FUNCTION; Schema: util; Owner: -


  		




  995
  1006
  
    
--


  		




  996
  1007
  
    

  		




  ......




  1277
  1288
  
    
CREATE FUNCTION drop_relations_like(name_regexp text, schema_regexp text DEFAULT ''::text, force boolean DEFAULT false) RETURNS void


  		




  1278
  1289
  
    
    LANGUAGE sql


  		




  1279
  1290
  
    
    AS $_$


  		




  1280
  
  
    
SELECT util.debug_print_sql(util.quote_func_call('util.drop_relations_like',


  		




  1281
  
  
    
util.quote_typed($1), util.quote_typed($2), util.quote_typed($3)))


  		




  
  1291
  
    
SELECT util.debug_print_func_call(util.quote_func_call(


  		




  
  1292
  
    
'util.drop_relations_like', util.quote_typed($1), util.quote_typed($2),


  		




  
  1293
  
    
util.quote_typed($3)))


  		




  1282
  1294
  
    
;


  		




  1283
  1295
  
    
SELECT util.drop_relation(relation, $3)


  		




  1284
  1296
  
    
FROM util.show_relations_like($1, $2) relation


  		












Also available in:  Unified diff