Project

General

Profile

« Previous | Next » 

Revision 12353

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/util.sql: drop_relation(regclass), rename_relation(regclass): use util.qual_name() instead of ::text so that the schema qualifier is always included in the debug SQL

View differences:

trunk/schemas/util.sql
1052 1052 
CREATE FUNCTION drop_relation(relation regclass, force boolean DEFAULT false) RETURNS void
1053 1053 
    LANGUAGE sql
1054 1054 
    AS $_$
1055 
SELECT util.drop_relation(util.relation_type($1), $1::text, $2)
1055 
/* use util.qual_name() instead of ::text so that the schema qualifier is always
1056 
included in the debug SQL */
1057 
SELECT util.drop_relation(util.relation_type($1), util.qual_name($1), $2)
1056 1058 
$_$;
1057 1059 

  		




  1058
  1060
  
    

  		




  ......




  2382
  2384
  
    
CREATE FUNCTION rename_relation(from_ regclass, to_ text) RETURNS void


  		




  2383
  2385
  
    
    LANGUAGE sql


  		




  2384
  2386
  
    
    AS $_$


  		




  2385
  
  
    
SELECT util.rename_relation($1::text, $2)


  		




  
  2387
  
    
/* use util.qual_name() instead of ::text so that the schema qualifier is always


  		




  
  2388
  
    
included in the debug SQL */


  		




  
  2389
  
    
SELECT util.rename_relation(util.qual_name($1), $2)


  		




  2386
  2390
  
    
$_$;


  		




  2387
  2391
  
    

  		




  2388
  2392
  
    

  		












Also available in:  Unified diff