Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 12779 over 10 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 13771 over 10 years Aaron Marcuse-Kubitza schemas/VegBIEN/taxonomy/: moved into schemas/V...
  backups 13902 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 13854 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/web_app/protocol/
  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 14125 over 10 years Aaron Marcuse-Kubitza fix: inputs/.TNRS/schema.sql: taxon_match: clus...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 14074 over 10 years Aaron Marcuse-Kubitza bugfix: lib/sql_io.py: put_table(): handle_Miss...
  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 14131 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: cluster(): support omitting i...
  validation 13963 over 10 years Aaron Marcuse-Kubitza validation/completeness/BIENDatesPopulated.xlsx...
  web 14121 over 10 years Aaron Marcuse-Kubitza web/username_prefix.php: remove padding used to...
  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.1 KB 14091 over 10 years Aaron Marcuse-Kubitza /README.TXT: Notes on system stability: added w...
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
14131 07/19/2014 02:47 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster(): support omitting index to recluster a table

14130 07/19/2014 02:26 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use util.cluster()

14129 07/19/2014 02:24 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): documented that this runs cluster only once if called repeatedly

14128 07/19/2014 02:24 AM Aaron Marcuse-Kubitza

schemas/util.sql: added cluster(), which reclusters each time

14127 07/19/2014 02:10 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use simpler `LANGUAGE sql` now that we're using util.eval() instead of EXECUTE

14126 07/19/2014 02:03 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use util.eval() instead of EXECUTE to print the CLUSTER statement (if any) it's using

14125 07/18/2014 11:40 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: cluster the table so the rows are always exported in the same order, even when an UPDATE statement is used to run triggers

14124 07/18/2014 11:28 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: cluster_once(): need to use just the name of the index, without the schema prefix

14123 07/18/2014 05:00 PM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use simpler IS DISTINCT FROM instead of array !=

14122 07/18/2014 03:18 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added _accepted{genus,specific_epithet} derived column, using the steps at wiki.vegpath.org/Postgres_queries#maintaining-derived-column-formulas-across-column-renames

View revisions

Also available in: Atom