Project

General

Profile

« Previous | Next » 

Revision 14258

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/util.sql: derived_col_update(): steps to modify: also need to run util.derived_cols_populate()

View differences:

trunk/inputs/.TNRS/schema.sql
384 384 

  		




  385
  385
  
    
to modify:


  		




  386
  386
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("*Accepted_name_species", '' ''::text)$$)::util.derived_col_def);


  		




  
  387
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  387
  388
  
    
';


  		




  388
  389
  
    

  		




  389
  390
  
    

  		




  ......




  396
  397
  
    

  		




  397
  398
  
    
to modify:


  		




  398
  399
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col, $$"__accepted_{genus,specific_epithet}"[1]$$)::util.derived_col_def);


  		




  
  400
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  399
  401
  
    
';


  		




  400
  402
  
    

  		




  401
  403
  
    

  		




  ......




  408
  410
  
    

  		




  409
  411
  
    
to modify:


  		




  410
  412
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]specificEpithet__@DwC__@vegpath.org'')::util.col, $$"__accepted_{genus,specific_epithet}"[2]$$)::util.derived_col_def);


  		




  
  413
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  411
  414
  
    
';


  		




  412
  415
  
    

  		




  413
  416
  
    

  		












  

    
      trunk/schemas/util.sql
    
  





  1964
  1964
  
    

  		




  1965
  1965
  
    
to modify:


  		




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


  		




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


  		




  1967
  1968
  
    
');


  		




  1968
  1969
  
    

  		




  1969
  1970
  
    
-- if table has data, initially disabled because not yet populated


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19496
  19496
  
    

  		




  19497
  19497
  
    
to modify:


  		




  19498
  19498
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("*Accepted_name_species", '' ''::text)$$)::util.derived_col_def);


  		




  
  19499
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  19499
  19500
  
    
';


  		




  19500
  19501
  
    

  		




  19501
  19502
  
    

  		




  ......




  19508
  19509
  
    

  		




  19509
  19510
  
    
to modify:


  		




  19510
  19511
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col, $$"__accepted_{genus,specific_epithet}"[1]$$)::util.derived_col_def);


  		




  
  19512
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  19511
  19513
  
    
';


  		




  19512
  19514
  
    

  		




  19513
  19515
  
    

  		




  ......




  19520
  19522
  
    

  		




  19521
  19523
  
    
to modify:


  		




  19522
  19524
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]specificEpithet__@DwC__@vegpath.org'')::util.col, $$"__accepted_{genus,specific_epithet}"[2]$$)::util.derived_col_def);


  		




  
  19525
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  19523
  19526
  
    
';


  		




  19524
  19527
  
    

  		




  19525
  19528
  
    

  		












Also available in:  Unified diff