Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 12779 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: use new begin_target instead of `ec...
  _archive 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 14301 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/Morphospecies and scope.eml*...
  backups 14334 over 10 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 14099 over 10 years Aaron Marcuse-Kubitza bin/import_all: hidden_srcs(): removed `by_col=...
  config 14064 over 10 years Aaron Marcuse-Kubitza fix: config/VirtualBox_VMs/vegbiendev/README.TX...
  derived 14298 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/Morphospecies and scope.eml*...
  downloads 13537 over 10 years Aaron Marcuse-Kubitza added downloads/
  exports 13929 over 10 years Aaron Marcuse-Kubitza exports/2014-6-4.Iara_Lacher.reserve_prioritiza...
  inputs 14347 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/.TNRS/schema.sql: taxon_match: u...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 14348 over 10 years Aaron Marcuse-Kubitza lib/sh/sync.sh: db_snapshot(): before backing u...
  mappings 13947 over 10 years Aaron Marcuse-Kubitza fix: mappings/VegCore-VegBIEN.csv: mapped DwC y...
  planning 13880 over 10 years Aaron Marcuse-Kubitza planning/meetings/BIEN conference call availabi...
  schemas 14352 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: check_constraint_disable(): d...
  validation 13963 over 10 years Aaron Marcuse-Kubitza validation/completeness/BIENDatesPopulated.xlsx...
  web 14336 over 10 years Aaron Marcuse-Kubitza web/username_prefix.php: substitutions: also su...
  wiki 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
.htaccess 326 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
LICENSE.TXT 6.17 KB 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
Makefile 12.9 KB 14068 over 10 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres_restart-*: argument...
README.TXT 34.4 KB 14197 over 10 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Full database import: adde...
fix_perms 97 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 518 Bytes 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
unmapped_terms.csv 33 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • svn:ignore: extern

Latest revisions

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

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.

View revisions

Also available in: Atom