Project

General

Profile

Statistics
| Revision:

root @ 8331

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 7564 almost 12 years Aaron Marcuse-Kubitza lib/common.Makefile: remote server: Use jupiter...
  bin 8320 over 11 years Aaron Marcuse-Kubitza bin/make_analytical_db: Commented out export_an...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  inputs 8327 over 11 years Aaron Marcuse-Kubitza inputs/FIA/occurrence_all/import: Added occurre...
  lib 8301 over 11 years Aaron Marcuse-Kubitza lib/table.run: template: import(): Also pass "$...
  mappings 8235 over 11 years Aaron Marcuse-Kubitza mappings/VegCore.htm: Renamed salvias_plots tab...
  planning 8315 over 11 years Aaron Marcuse-Kubitza Added planning/workflow/normalized_vs_denormali...
  schemas 8331 over 11 years Aaron Marcuse-Kubitza schemas/util.sql: mk_subset_by_row_num_func(): ...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
  web 8228 over 11 years Aaron Marcuse-Kubitza Added web/main/svn*/, now using .htaccess to fo...
Makefile 12.1 KB 8081 over 11 years Aaron Marcuse-Kubitza root Makefile: Installation: Fixed bug where ne...
README.TXT 19.7 KB 8319 over 11 years Aaron Marcuse-Kubitza bin/export_analytical_db: Replaced analytical_a...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
8331 04/04/2013 08:43 AM Aaron Marcuse-Kubitza

schemas/util.sql: mk_subset_by_row_num_func(): regular subset function: Fixed bug where need to add 1 to the 0-based offset_ to get the 1-based row_num (which is usually a serial column)
8330 04/04/2013 08:38 AM Aaron Marcuse-Kubitza

schemas/util.sql: mk_subset_by_row_num_func(): regular subset function: Fixed bug where need to subtract 1 from the end row_num because BETWEEN limits are inclusive of the bounds
8329 04/04/2013 08:33 AM Aaron Marcuse-Kubitza

schemas/util.sql: mk_subset_by_row_num_func(): regular subset function: Fixed bug where also need to COALESCE offset_ to 0 when it's added to the limit_
8328 04/04/2013 08:20 AM Aaron Marcuse-Kubitza

schemas/util.sql: mk_subset_by_row_num_func(): subset function which turns off enable_sort: Fixed bug where need to pass ($2, $3) instead of ($1, $2) to the regular subset function
8327 04/04/2013 08:14 AM Aaron Marcuse-Kubitza

inputs/FIA/occurrence_all/import: Added occurrence_all-row_num column for use with mk_subset_by_row_num_func()
8326 04/04/2013 08:12 AM Aaron Marcuse-Kubitza

schemas/util.sql: mk_subset_by_row_num_func(): Also create subset function which turns off enable_sort. This is used for limit values greater than ~100,000 to avoid unwanted slow sorts. The regular subset function is still needed to work with EXPLAIN, so that it produces expanded output instead of just a function scan.
8325 04/04/2013 07:27 AM Aaron Marcuse-Kubitza

schemas/util.sql: Added mk_subset_by_row_num_func()
8324 04/04/2013 07:10 AM Aaron Marcuse-Kubitza

schemas/util.sql: Added type_qual_name()
8323 04/04/2013 06:33 AM Aaron Marcuse-Kubitza

schemas/util.sql: force_update_view(): Fixed bug where also need to drop view for "cannot change name of view column" errors
8322 04/04/2013 05:24 AM Aaron Marcuse-Kubitza

inputs/FIA/occurrence_all/import: Use new force_update_view(), which only drops the view if its columns have changed and otherwise just uses CREATE OR REPLACE VIEW, rather than always first running DROP VIEW IF EXISTS

View all revisions | View revisions

Also available in: Atom