Project

General

Profile

Statistics
| Revision:

root/trunk @ 12525

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 12394 almost 11 years Aaron Marcuse-Kubitza bin/psql_verbose_vegbien: use \\ instead of \ i...
  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 12516 over 10 years Aaron Marcuse-Kubitza bugfix: *.sql: public.source_by_shortname(): ne...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 12405 almost 11 years Aaron Marcuse-Kubitza bugfix: lib/common.Makefile: `svn add`: need to...
  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 12525 over 10 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: rm_all_queries(): all...
  validation 12516 over 10 years Aaron Marcuse-Kubitza bugfix: *.sql: public.source_by_shortname(): ne...
  web 12442 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 28.2 KB 12426 almost 11 years Aaron Marcuse-Kubitza /README.TXT: use full hostname for jupiter so t...
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
12525 02/27/2014 06:42 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: rm_all_queries(): all-schemas mode: also remove queries that are only present on the input side, so that the input side can also be re-created from the DDL file
12524 02/27/2014 06:36 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: rm_all_queries(): documented that this actually does remove queries in all schemas when schema is NULL, because rm_query_view(public_validations.view) searches all schemas
12523 02/27/2014 04:37 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: top_plot view: renamed to plot, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)
12522 02/27/2014 04:12 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)
12521 02/27/2014 03:51 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)
12520 02/27/2014 02:20 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: source_by_shortname(): documented exact time that the slow query ran for (5013s = ~1.5 hours)
12519 02/27/2014 02:07 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations: schema comment: documented how to sync the queries with schemas/vegbien.sql
12518 02/27/2014 02:05 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations.rm_all_queries(): when called with no args, operate on public_validations instead of all schemas, since this is the more common use case (replacing just the output queries, not both input and output)
12517 02/27/2014 01:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: rm_query_group(): documented that this only removes validations output queries (in public_validations), as it is designed for use in updating all output queries at once from the testing DB
12516 02/27/2014 01:27 PM Aaron Marcuse-Kubitza

bugfix: *.sql: public.source_by_shortname(): need to wrap it in a nested SELECT because Postgres incorrectly does not constant-fold (inline) it, leading to a slowdown when it is therefore run many times. this is done using the steps at wiki.vegpath.org/Postgres_queries#wrap-function-call-in-nested-SELECT .

View revisions

Also available in: Atom