Project

General

Profile

Statistics
| Revision:
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 14350 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: rematerialize_view(): support...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
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)

14347 07/26/2014 05:16 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: use wrapper for util.remove_prefix() so CHECK constraints that use it don't get dropped when the util schema is reinstalled

14346 07/26/2014 04:32 PM Aaron Marcuse-Kubitza

schemas/public_.sql: *_view_modify(): use util.rematerialize_view(), which now supports table mods

14345 07/26/2014 03:47 PM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): added support for table mods to run after creating table

14344 07/26/2014 04:53 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: rematerialize_view(): don't populate unless recreate() can successfully recreate the dependent views, to avoid populating the entire table (which for some views can take hours) only to have the changes rolled back by a failing dependent view

14343 07/26/2014 04:42 AM Aaron Marcuse-Kubitza

schemas/util.sql: removed no longer used materialize_view(). use util.copy() instead.

14342 07/26/2014 04:41 AM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): call util.copy() directly instead of via util.materialize_view()

14341 07/26/2014 04:35 AM Aaron Marcuse-Kubitza

schemas/util.sql: removed no longer used copy_types_and_data(). use util.materialize_view() instead.

View all revisions | View revisions

Also available in: Atom