Project

General

Profile

Statistics
| Revision:

root @ 13936

Name Size Revision Age Author Comment
  branches 11969 about 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 about 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 13936 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: added sql(col_ref)
  • svn:ignore: extern

Latest revisions

# Date Author Comment
13936 07/09/2014 09:37 AM Aaron Marcuse-Kubitza

schemas/util.sql: added sql(col_ref)
13935 07/09/2014 09:35 AM Aaron Marcuse-Kubitza

schemas/util.sql: added mk_set_comment(on_ text, comment text)
13934 07/09/2014 07:53 AM Aaron Marcuse-Kubitza

schemas/util.sql: added comment(col_ref)
13933 07/09/2014 07:50 AM Aaron Marcuse-Kubitza

schemas/util.sql: added col_num(col_ref)
13932 07/09/2014 07:03 AM Aaron Marcuse-Kubitza

removed no longer needed inputs/.TNRS/grants.sql, since the grants in schema.sql are now being run
13931 07/09/2014 07:03 AM Aaron Marcuse-Kubitza

bugfix: inputs/input.Makefile: sql/install: schema.sql should not be passed through pg_dump_limit because it contains GRANT statements that need to be run
13930 07/09/2014 06:22 AM Aaron Marcuse-Kubitza

schemas/public_.sql: iucn_red_list_view: documented how to regenerate iucn_red_list from this
13929 07/08/2014 04:17 PM Aaron Marcuse-Kubitza

exports/2014-6-4.Iara_Lacher.reserve_prioritization.csv.run: documented runtime (7.5 min) and rowcount (3.5 million)
13928 07/08/2014 03:23 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: fixed slowdown in materializing the view, which was caused by source__observation_type(), by replacing this with a LEFT JOIN as was done for is_threatened_iucn
13927 07/07/2014 07:33 AM Aaron Marcuse-Kubitza

schemas/util.sql: in_south_america(): optimized by using BETWEEN instead of util.contained_within__no_dateline(). this reduces the filter time for 2014-6-4.Iara_Lacher.reserve_prioritization by about 10%.

View all revisions | View revisions

Also available in: Atom