Project

General

Profile

« Previous | Next » 

Revision 14275

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/util.sql: derived_col_update(): add steps to rename column

View differences:

util.sql
1976 1976 
SELECT util.set_comment(def.col, '
1977 1977 
derived column; = '||util.derived_col_expr(def.col)||'
1978 1978 

  		




  1979
  
  
    
to modify:


  		




  
  1979
  
    
to modify expr:


  		




  1980
  1980
  
    
SELECT util.derived_col_update('||util.quote_typed(def)||');


  		




  1981
  1981
  
    
SELECT util.derived_cols_populate('||util.quote_typed((def).col.table_)||');


  		




  
  1982
  
    

  		




  
  1983
  
    
to rename:


  		




  
  1984
  
    
# rename column


  		




  
  1985
  
    
# rename CHECK constraint


  		




  
  1986
  
    
SELECT util.derived_cols_update('||util.quote_typed((def).col.table_)||');


  		




  1982
  1987
  
    
');


  		




  1983
  1988
  
    

  		




  1984
  1989
  
    
SELECT util.derived_cols_trigger_update((def).col.table_);


  		












Also available in:  Unified diff