Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _archive 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 12225 over 10 years Aaron Marcuse-Kubitza _license/non-open-source/applies_to.txt: clarif...
  backups 12176 over 10 years Aaron Marcuse-Kubitza added backups/vegbien.r12025.backup.md5
  bin 12394 over 10 years Aaron Marcuse-Kubitza bin/psql_verbose_vegbien: use \\ instead of \ i...
  config 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  derived 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  exports 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  inputs 12417 over 10 years Aaron Marcuse-Kubitza fix: inputs/SALVIAS/validations.sql: _plots_02_...
  issues 12124 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 12405 over 10 years Aaron Marcuse-Kubitza bugfix: lib/common.Makefile: `svn add`: need to...
  mappings 12039 over 10 years Aaron Marcuse-Kubitza inputs/input.Makefile: verify/%.out: use a *.sq...
  planning 12020 over 10 years Aaron Marcuse-Kubitza planning/resources/dev_machine.specs/sys_info.s...
  schemas 12444 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: join_strs_transform()...
  validation 12404 over 10 years Aaron Marcuse-Kubitza fix: validation/aggregating/plots/SALVIAS/bien3...
  web 12442 over 10 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
  wiki 12124 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
.htaccess 326 Bytes 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
LICENSE.TXT 6.18 KB 12124 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
Makefile 13.4 KB 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
README.TXT 28.2 KB 12426 over 10 years Aaron Marcuse-Kubitza /README.TXT: use full hostname for jupiter so t...
fix_perms 97 Bytes 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 511 Bytes 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
unmapped_terms.csv 33 KB 11970 over 10 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12444 02/25/2014 12:07 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: join_strs_transform(): added back STRICT qualifier because it must be declared STRICT to use the special handling of STRICT aggregating functions

12443 02/25/2014 11:56 AM Aaron Marcuse-Kubitza

schemas/util.sql: %==(anyelement, anyelement): needs to be declared STABLE instead of IMMUTABLE because it depends on the search_path (as described at http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Function%20Volatility%20Categories%20**)

12442 02/25/2014 11:49 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: difference between STABLE and IMMUTABLE: functions that depend on the search_path: clarified that the confusing effects of using IMMUTABLE for one of these functions are only noticeable if the function is called on only constant values in a PL/pgSQL function (in which case the wrong search_path (the one in effect at create time) will be used)

12441 02/25/2014 11:37 AM Aaron Marcuse-Kubitza

schemas/util.sql, vegbien.sql: do not declare IMMUTABLE SQL-language functions as STRICT, because this prevents them from being inlined (as documented in the util schema comment)

12440 02/25/2014 11:23 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added explanation of the difference between STABLE and IMMUTABLE, and common pitfalls in using IMMUTABLE when you should use STABLE. svn: added troubleshooting steps for running `svn upgrade` after the last Mac system update, which upgrades svn.

12439 02/25/2014 10:55 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff(text, text): use util.typeof() instead of pg_typeof() so the outputted query is runnable in any search_path

12438 02/25/2014 10:50 AM Aaron Marcuse-Kubitza

schemas/util.sql: added typeof(), which unlike pg_typeof() uses util.qual_name() to create a search_path-independent name

12437 02/25/2014 10:33 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: quote_typed(): schema-qualify the type so the expression does not depend on the search_path

12436 02/25/2014 10:31 AM Aaron Marcuse-Kubitza

schemas/util.sql: %== : use custom keys() function for the type, so that the user only has to get the keys from their value, not also write the comparison of those keys

12435 02/25/2014 10:29 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: synced from DB, which changes the order of the ~type tables

View revisions

Also available in: Atom