Project

General

Profile

« Previous | Next » 

Revision 9990

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs: documented that when changing this table's schema, you must also make the same changes on vegbiendev. included sample util.set_col_types() call with runtime (4 min).

View differences:

schema.sql
24 24 

  		




  25
  25
  
    
/* IMPORTANT: when changing this table's schema, you must regenerate data.sql:


  		




  26
  26
  
    
$ <this_file>/../test_taxonomic_names/test_scrub


  		




  
  27
  
    
you must also make the same changes on vegbiendev: e.g.


  		




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


  		




  
  29
  
    
  ('col', 'new_type')


  		




  
  30
  
    
]::util.col_cast[]);


  		




  
  31
  
    
runtime: 4 min ("242100 ms")


  		




  27
  32
  
    
*/


  		




  28
  33
  
    
CREATE TABLE tnrs


  		




  29
  34
  
    
(


  		












Also available in:  Unified diff