Project

General

Profile

« Previous | Next » 

Revision 14312

fix: inputs/.TNRS/schema.sql: taxon_match: COMMENT: updated util.derived_cols_sync() to util.derived_cols_update()

View differences:

trunk/inputs/.TNRS/schema.sql
509 509

  
510 510
COMMENT ON TABLE taxon_match IS '
511 511
whenever columns are renamed:
512
SELECT util.derived_cols_sync(''"TNRS".taxon_match'');
512
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
513 513

  
514 514
to remove columns or add columns at the end:
515 515
$ rm=1 inputs/.TNRS/data.sql.run
trunk/schemas/vegbien.sql
19613 19613

  
19614 19614
COMMENT ON TABLE taxon_match IS '
19615 19615
whenever columns are renamed:
19616
SELECT util.derived_cols_sync(''"TNRS".taxon_match'');
19616
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
19617 19617

  
19618 19618
to remove columns or add columns at the end:
19619 19619
$ rm=1 inputs/.TNRS/data.sql.run

Also available in: Unified diff