Project

General

Profile

Statistics
| Revision:
  • svn:ignore: extern

# Date Author Comment
14185 07/20/2014 05:55 AM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_col_constraints_enable()

14184 07/20/2014 05:28 AM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint__disabled(), which creates a CHECK constraint which is initially disabled

14183 07/20/2014 05:27 AM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint__disabled(), which creates a CHECK constraint which is initially disabled

14182 07/20/2014 05:07 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: run_triggers(): need to re-sort rows if table needs this

14181 07/20/2014 05:05 AM Aaron Marcuse-Kubitza

schemas/util.sql: added try_cluster()

14180 07/20/2014 04:05 AM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_cols_populate()

14179 07/20/2014 04:04 AM Aaron Marcuse-Kubitza

schemas/util.sql: added run_triggers(regclass)

14178 07/20/2014 04:00 AM Aaron Marcuse-Kubitza

schemas/util.sql: added first_col(regclass)

14177 07/20/2014 02:42 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: read-only functions should be STABLE rather than VOLATILE

14176 07/20/2014 02:42 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: functions that access the DB must be STABLE rather than IMMUTABLE

14175 07/20/2014 02:23 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_col_defs(): derived columns must be returned in table order (which should = dependency order), so that they are populated in dependency order

14174 07/20/2014 02:17 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: remove_prefix(), remove_suffix(): must be declared STRICT to handle NULL properly

14173 07/20/2014 02:16 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: remove_suffix(): need to use quote_nullable(str) so a NULL str doesn't NULL out the entire message

14172 07/20/2014 02:10 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: remove_prefix(): need to use quote_nullable(str) so a NULL str doesn't NULL out the entire message

14171 07/20/2014 02:09 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: raise(): use new quote_as_str() to avoid "RAISE statement option cannot be null" errors

14170 07/20/2014 02:08 AM Aaron Marcuse-Kubitza

schemas/util.sql: added quote_as_str()

14169 07/19/2014 11:23 PM Aaron Marcuse-Kubitza

schemas/util.sql: added CAST (util.col AS util.derived_col_def)

14168 07/19/2014 11:05 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_col_def(col): use existing util.check_constraint_def()

14167 07/19/2014 11:01 PM Aaron Marcuse-Kubitza

schemas/util.sql: added CAST (util.col AS util.table_item)

14166 07/19/2014 10:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_col_def(col)

14165 07/19/2014 10:30 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_disable()

14164 07/19/2014 10:23 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: check_constraint_drop(): need IF EXISTS

14163 07/19/2014 10:09 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_expr_disable()

14162 07/19/2014 09:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: check_constraint_enable(): documented that this is idempotent

14161 07/19/2014 09:21 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: documented that whenever columns are renamed, util.derived_cols_sync() should be run

14160 07/19/2014 09:14 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_cols_sync(): also create trigger, since this is necessary for a complete sync

14159 07/19/2014 09:13 PM Aaron Marcuse-Kubitza

schemas/util.sql: added name(regprocedure)

14158 07/19/2014 09:02 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_cols_sync(): set the trigger name in a var

14157 07/19/2014 08:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_enable()

14156 07/19/2014 08:46 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_replace()

14155 07/19/2014 08:43 PM Aaron Marcuse-Kubitza

schemas/util.sql: added CAST (util.table_item AS util.check_constraint_def)

14154 07/19/2014 08:38 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_drop()

14153 07/19/2014 08:02 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_col_expr_from_check_constraint(): enable initially-disabled exprs

14152 07/19/2014 08:00 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_expr_enable()

14151 07/19/2014 07:42 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: check_constraint view: def: use pg_get_expr() with pretty-print, to avoid extra () that complicate parsing

14150 07/19/2014 06:54 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match__fill_derived(): updated using new util.derived_cols_sync()

14149 07/19/2014 06:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_cols_sync()

14148 07/19/2014 06:45 PM Aaron Marcuse-Kubitza

bugfix: CAST (util.check_constraint_def AS util.derived_col_def): need to extract the derived column expr from the CHECK constraint expr

14147 07/19/2014 06:44 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_col_expr_from_check_constraint()

14146 07/19/2014 06:39 PM Aaron Marcuse-Kubitza

schemas/util.sql: added extract_str()

14145 07/19/2014 06:34 PM Aaron Marcuse-Kubitza

schemas/util.sql: added remove_suffix()

14144 07/19/2014 06:21 PM Aaron Marcuse-Kubitza

schemas/util.sql: added remove_prefix()

14143 07/19/2014 05:47 PM Aaron Marcuse-Kubitza

schemas/util.sql: added CAST (util.table_item AS util.col)

14142 07/19/2014 05:37 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_col_defs(): return derived_col_def instead of check_constraint_def

14141 07/19/2014 05:36 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_col_def type with cast from util.check_constraint_def

14140 07/19/2014 04:51 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_col_defs()

14139 07/19/2014 04:35 PM Aaron Marcuse-Kubitza

schemas/util.sql: check_constraint_defs(): use new util.check_constraint view

14138 07/19/2014 04:30 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint view

14137 07/19/2014 03:53 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_defs()

14136 07/19/2014 03:53 PM Aaron Marcuse-Kubitza

schemas/util.sql: added check_constraint_def type

14135 07/19/2014 03:51 PM Aaron Marcuse-Kubitza

schemas/util.sql: added table_item type

14134 07/19/2014 01:59 PM Aaron Marcuse-Kubitza

schemas/util.sql: col_ref: renamed to just col

14133 07/19/2014 01:38 PM Aaron Marcuse-Kubitza

web/username_prefix.php: remove padding used to visually separate elements: documented that this leaves embedded _ (eg. x_y) untouched

14132 07/19/2014 02:52 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: to populate a new column: also need to recluster table so rows are exported in sorted order

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

14121 07/18/2014 02:01 AM Aaron Marcuse-Kubitza

web/username_prefix.php: remove padding used to visually separate elements: documented that this also removes a leading __ that indicates an internal field

14120 07/17/2014 07:18 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Quick links: added VegBIEN data dictionary spreadsheet, TNRS data dictionary.

14119 07/17/2014 06:15 PM Aaron Marcuse-Kubitza

fix: web/username_prefix.php: transposes: changed recommended syntax to y~x@url so that _y~ lines up vertically with [y] paths

14118 07/17/2014 06:11 PM Aaron Marcuse-Kubitza

web/username_prefix.php: removed special category comments syntax because this is now handled by transposes and insertion comments

14117 07/17/2014 06:10 PM Aaron Marcuse-Kubitza

web/username_prefix.php: added support for transposes ( y~x_@url -> x_y@url , Y~x@url -> xY@url ), which can be used to put the category in a column name first without duplicating the category

14116 07/17/2014 05:35 PM Aaron Marcuse-Kubitza

web/username_prefix.php: removed linewraps code because Google spreadsheets no longer supports wrapping on a - , and because a shorter syntax for category comments is now available

14115 07/17/2014 05:32 PM Aaron Marcuse-Kubitza

web/username_prefix.php: category comments: moved _-_ outside [] in comparison example since it will be deleted separately

14114 07/17/2014 05:27 PM Aaron Marcuse-Kubitza

bugfix: web/username_prefix.php: category comments: need /__/ around regexp

14113 07/17/2014 05:24 PM Aaron Marcuse-Kubitza

web/username_prefix.php: category comments: added support for a shorter syntax than [x_-_]y@url : x+y@url -> y@url

14112 07/17/2014 04:14 PM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: updated

14111 07/17/2014 04:13 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: added back * prefixes on TNRS-namespace column names

14110 07/17/2014 03:34 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: taxon_best_match: don't alias to `s` since this is no longer a nested select

14109 07/17/2014 03:32 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: nested select: use just taxon_best_match since this no longer performs renamings

14108 07/17/2014 03:27 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: renamed output columns to match input columns, so that the nested select would not be performing any renamings

14107 07/17/2014 03:05 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon: added all columns from taxon_match (some of them apparently hadn't been included in MatchedTaxon)

14106 07/17/2014 03:01 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: reordered columns to match taxon_match

14105 07/17/2014 02:38 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon: added all columns from taxon_match (some of them apparently hadn't been included in MatchedTaxon)

14104 07/17/2014 01:02 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: added back Family_matched, which had gotten merged with Name_matched_accepted_family when TNRS temporarily stopped populating Name_matched_accepted_family

14103 07/17/2014 12:32 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: taxonomicStatus: moved outside the inner SELECT so that the inner SELECT would consist solely of renamings

14102 07/17/2014 12:12 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: removed unneeded "Name_matched." prefix on source-specific names (only the * is needed because there is only one table)

14101 07/17/2014 12:10 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: view_is_subset(): auto-updatable views that are not plain subsets: include ones with WHERE clauses

14100 07/17/2014 12:03 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: view_is_subset(): also need to handle auto-updatable views that are not plain subsets (there are some of these)

14099 07/17/2014 09:05 AM Aaron Marcuse-Kubitza

bin/import_all: hidden_srcs(): removed `by_col=1` because these should be done in the same mode as the main datasources

14098 07/16/2014 07:55 PM Aaron Marcuse-Kubitza

schemas/public_.sql: removed no longer used threatened_taxonlabel. use iucn_red_list instead.

14097 07/16/2014 07:39 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: analytical_stem_view: don't use threatened_taxonlabel, which was never populated correctly. instead, this can eventually be rewritten to use new iucn_red_list.

14096 07/16/2014 07:13 PM Aaron Marcuse-Kubitza

bin/make_analytical_db: removed threatened_taxonlabel because this is now handled by iucn_red_list

14095 07/16/2014 07:12 PM Aaron Marcuse-Kubitza

bin/make_analytical_db: added iucn_red_list_view_modify()

14094 07/16/2014 06:48 PM Aaron Marcuse-Kubitza

bin/make_analytical_db: removed unused code to create views in the analytical_db schema

14093 07/16/2014 06:35 PM Aaron Marcuse-Kubitza

bin/make_analytical_db: merged mk_table and mk_analytical_table since they now do the same thing

14092 07/16/2014 06:34 PM Aaron Marcuse-Kubitza

bin/make_analytical_db: removed unused code to create views in the analytical_db schema

14091 07/16/2014 05:05 PM Aaron Marcuse-Kubitza

/README.TXT: Notes on system stability: added warning that when shutting down the VM, one should always first stop Postgres, to prevent the OS from SIGKILLing it

14090 07/16/2014 05:04 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/Source/header.csv: updated

14089 07/16/2014 03:50 PM Aaron Marcuse-Kubitza

bugfix: bin/with_all: isset(): need to use `&>/dev/null` instead of `>&-`, etc because closing an fd causes declare to return false

14088 07/16/2014 03:31 PM Aaron Marcuse-Kubitza

bugfix: bin/with_all, import_all: don't disown processes because they should be auto-killed if the shell is (disown was only needed before we used screen)

14087 07/16/2014 03:24 PM Aaron Marcuse-Kubitza

bugfix: Full database import: need nested shell to prevent errexit from closing the window

14086 07/16/2014 01:24 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: analytical_stem_view_modify(): added columns: need to include COMMENT statements