Project

General

Profile

Statistics
| Revision:

root/trunk @ 12275

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 12041 almost 11 years Aaron Marcuse-Kubitza bugfix: bin/pg_dump_vegbien: fixed arg-count ch...
  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 12246 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/bien2_traits/validations.sql: us...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  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 12275 almost 11 years Aaron Marcuse-Kubitza schemas/util.sql: added ltrim_nl()
  validation 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  web 12239 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 27.4 KB 12227 almost 11 years Aaron Marcuse-Kubitza /README.TXT: Schema changes: clarified that the...
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
12275 02/17/2014 11:37 AM Aaron Marcuse-Kubitza

schemas/util.sql: added ltrim_nl()
12274 02/17/2014 11:25 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: setting search_path locally: also need to set function option search_path, in order to limit the effects of `SET LOCAL search_path` (mk_set_search_path()) to the current function (http://www.postgresql.org/docs/9.1/static/sql-set.html#AEN75423)
12273 02/17/2014 11:14 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: setting search_path locally: need to use `SET LOCAL search_path TO` instead of `PERFORM set_config(search_path, ..., is_local := true)` because the meaning of is_local refers to the entire transaction, not just the current function (as for LOCAL)
12272 02/17/2014 11:05 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_set_search_path(VARIADIC schemas text[])
12271 02/17/2014 10:54 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_use_own_schema()
12270 02/17/2014 10:52 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_set_search_path()
12269 02/17/2014 10:17 AM Aaron Marcuse-Kubitza

schemas/util.sql: use builtin string_agg(..., ) instead of concat()
12268 02/17/2014 12:34 AM Aaron Marcuse-Kubitza

schemas/util.sql: added qual_name(type unknown) to avoid needing to explicitly specify the type of an input string
12267 02/17/2014 12:31 AM Aaron Marcuse-Kubitza

schemas/util.sql: qual_name(table_ regclass): use ::text with search_path=pg_temp like qual_name(type regtype), rather than casting to text and then using qual_name(type regtype)
12266 02/17/2014 12:25 AM Aaron Marcuse-Kubitza

schemas/util.sql: type_qual_name(type regtype): renamed to qual_name(type regtype) to match qual_name(table_ regclass)

View revisions

Also available in: Atom