Project

General

Profile

Statistics
| Revision:

root @ 14357

Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 14357 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: taxon_match.__...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14357 07/26/2014 07:43 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match.__accepted_infraspecific_label: need to use case-insensitive matching of the removed prefix because TNRS lowercases part of the Accepted_name
14356 07/26/2014 07:40 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
14355 07/26/2014 06:54 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching
14354 07/26/2014 06:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: added case-sensitive-optional versions of starts_with(), ends_with()
14353 07/26/2014 06:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: added canon_case(str text, case_sensitive boolean)
14352 07/26/2014 06:36 PM Aaron Marcuse-Kubitza

schemas/util.sql: check_constraint_disable(): documented that we can't use ADD CONSTRAINT NOT VALID for this because it does not disable the constraint completely, but instead causes new rows to be validated against it. the ADD CONSTRAINT NOT VALID behavior does not work for the derived columns use case of this function.
14351 07/26/2014 06:17 PM Aaron Marcuse-Kubitza

schemas/public_.sql: *_view_modify(): added repopulate param, which is passed to rematerialize_view()
14350 07/26/2014 06:14 PM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): support updating just the table's schema, without populating it
14349 07/26/2014 05:37 PM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): don't need extra eval() around table_mod_sql because recreate() performs eval()
14348 07/26/2014 05:28 PM Aaron Marcuse-Kubitza

lib/sh/sync.sh: db_snapshot(): before backing up, trim bloated temp files (eg. from rolled back changes)

View all revisions | View revisions

Also available in: Atom