Project

General

Profile

« Previous | Next » 

Revision 11617

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: schema comment: added steps to remake schema.sql and back up the new TNRS schema. documented that these steps should be run on vegbiendev.

View differences:

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
  
    
on vegbiendev:


  		




  
  24
  
    
# back up existing TNRS schema (in case of an accidental incorrect change):


  		




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


  		




  25
  26
  
    
$ svn up


  		




  26
  27
  
    
$ svn di


  		




  ......




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


  		




  30
  31
  
    
  (''col'', ''new_type'')


  		




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


  		




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


  		




  
  33
  
    
$ rm=1 inputs/.TNRS/schema.sql.run


  		




  
  34
  
    
# repeat until `svn di` shows no diff


  		




  
  35
  
    
# back up new TNRS schema:


  		




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


  		




  33
  37
  
    

  		




  34
  38
  
    

  		




  35
  39
  
    
SET search_path = "TNRS", pg_catalog;


  		












Also available in:  Unified diff