Project

General

Profile

« Previous | Next » 

Revision 9974

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_fields(): when changing this function: UPDATE statement: include TNRS schema since it may not be in the search_path

View differences:

schema.sql
66 66 
  WHERE score_ok("Max_score");
67 67 

  		




  68
  68
  
    
/* IMPORTANT: when changing this function, you must regenerate the derived cols:


  		




  69
  
  
    
UPDATE tnrs SET "Name_submitted" = "Name_submitted"


  		




  
  69
  
    
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted"


  		




  70
  70
  
    
runtime: 17 min ("4992166 rows affected, 1019907 ms execution time")


  		




  71
  71
  
    
*/


  		




  72
  72
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_fields()


  		












Also available in:  Unified diff