Project

General

Profile

Statistics
| Revision:
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 14344 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: rematerialize_view():...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14344 07/26/2014 04:53 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: rematerialize_view(): don't populate unless recreate() can successfully recreate the dependent views, to avoid populating the entire table (which for some views can take hours) only to have the changes rolled back by a failing dependent view

14343 07/26/2014 04:42 AM Aaron Marcuse-Kubitza

schemas/util.sql: removed no longer used materialize_view(). use util.copy() instead.

14342 07/26/2014 04:41 AM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): call util.copy() directly instead of via util.materialize_view()

14341 07/26/2014 04:35 AM Aaron Marcuse-Kubitza

schemas/util.sql: removed no longer used copy_types_and_data(). use util.materialize_view() instead.

14340 07/26/2014 04:20 AM Aaron Marcuse-Kubitza

schemas/util.sql: to_freq(): use util.copy() instead of util.copy_types_and_data() to avoid a dependency on util.copy_types_and_data()

14339 07/25/2014 09:57 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: copy_data(): also need to ANALYZE table after loading data into it

14338 07/25/2014 09:13 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view: use viewFullOccurrence_individual_view to avoid duplicated code between the views. this moves the stem-related columns to the end of the view.

14337 07/25/2014 06:26 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added viewFullOccurrence_individual_view

14336 07/25/2014 06:20 PM Aaron Marcuse-Kubitza

web/username_prefix.php: substitutions: also support "" because Postgres doubles " to escape them

14335 07/25/2014 06:17 PM Aaron Marcuse-Kubitza

web/username_prefix.php: added support for substitutions ( x."_y@url -> x.x_y@url ), which can be used when a table name is repeated in a column name

View all revisions | View revisions

Also available in: Atom