Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _archive 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 12225 almost 11 years Aaron Marcuse-Kubitza _license/non-open-source/applies_to.txt: clarif...
  backups 12176 almost 11 years Aaron Marcuse-Kubitza added backups/vegbien.r12025.backup.md5
  bin 12041 almost 11 years Aaron Marcuse-Kubitza bugfix: bin/pg_dump_vegbien: fixed arg-count ch...
  config 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  derived 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  exports 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  inputs 12286 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/bien2_traits/validations.sql: _t...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  mappings 12039 almost 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: verify/%.out: use a *.sq...
  planning 12020 almost 11 years Aaron Marcuse-Kubitza planning/resources/dev_machine.specs/sys_info.s...
  schemas 12322 almost 11 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: _traits_07_trait_valu...
  validation 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  web 12310 almost 11 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
  wiki 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
.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.18 KB 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
Makefile 13.4 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
README.TXT 27.4 KB 12227 almost 11 years Aaron Marcuse-Kubitza /README.TXT: Schema changes: clarified that the...
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 511 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
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
12322 02/20/2014 07:18 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: _traits_07_trait_value_and_units, _traits_08_taxonname_trait_and_value_for_first_5000_records: removed LIMIT to match the input queries

12321 02/20/2014 07:12 PM Aaron Marcuse-Kubitza

schemas/util.sql: materialize_query(): ANALYZE the created table so that it has the correct estimated rowcount

12320 02/20/2014 07:08 PM Aaron Marcuse-Kubitza

schemas/util.sql: added analyze_()

12319 02/20/2014 06:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: remake_diff_tables(): updated bien2_traits runtime (45 min) to include the now-properly-renamed views 6-8

12318 02/20/2014 06:14 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: remake_diff_tables(): documented runtime for bien2_traits (30 min)

12317 02/20/2014 05:52 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: renamed output views to match input views

12316 02/20/2014 04:52 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _traits_01_count_records (output side): documented runtime (4 min)

12315 02/20/2014 04:33 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): resolved ambiguous column references by renaming PL/pgSQL vars and adding table qualifiers

12314 02/20/2014 04:28 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): changed from STABLE to VOLATILE because the search_path can only be set in VOLATILE functions

12313 02/20/2014 04:19 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): can't be declared STRICT because it now has a 2nd param (schema_anchor) which is always NULL

View revisions

Also available in: Atom