Project

General

Profile

« Previous | Next » 

Revision 14258

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