Project

General

Profile

« Previous | Next » 

Revision 11616

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: schema comment: added steps to determine what changes need to be made on vegbiendev

View differences:

inputs/.TNRS/schema.sql
20 20 
--
21 21 

  		




  22
  22
  
    
COMMENT ON SCHEMA "TNRS" IS 'IMPORTANT: when changing this schema, you must also make the same changes on vegbiendev:


  		




  23
  
  
    
back up existing TNRS schema:


  		




  
  23
  
    
# back up existing TNRS schema:


  		




  24
  24
  
    
$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s")


  		




  25
  
  
    
make changes:


  		




  26
  
  
    
e.g. to set column types:


  		




  
  25
  
    
$ svn up


  		




  
  26
  
    
$ svn di


  		




  
  27
  
    
# make the changes shown in the diff


  		




  
  28
  
    
## to change column types:


  		




  27
  29
  
    
SELECT util.set_col_types(''"TNRS".tnrs'', ARRAY[


  		




  28
  30
  
    
  (''col'', ''new_type'')


  		




  29
  
  
    
]::util.col_cast[]); -- runtime: 9 min ("531282 ms")';


  		




  
  31
  
    
]::util.col_cast[]); -- runtime: 9 min ("531282 ms")


  		




  
  32
  
    
# repeat until `svn di` shows no diff';


  		




  30
  33
  
    

  		




  31
  34
  
    

  		




  32
  35
  
    
SET search_path = "TNRS", pg_catalog;


  		












Also available in:  Unified diff