Project

General

Profile

Statistics
| Revision:
  • svn:ignore: extern

# Date Author Comment
12382 02/23/2014 06:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: util.remake_diff_table(): don't force-re-create type_table. this allows type_table to be shared between multiple diff tables.

12381 02/23/2014 06:00 PM Aaron Marcuse-Kubitza

/README.TXT: to back up the version history: added steps to sync git to the local machine

12380 02/23/2014 05:55 PM Aaron Marcuse-Kubitza

added validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_complete.sql from Brad's e-mail

12379 02/23/2014 05:32 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: public_validations.remake_diff_table(in_view regclass): document how to regenerate the diff table, in a place that's readily available to someone using the table

12378 02/23/2014 05:08 PM Aaron Marcuse-Kubitza

schemas/util.sql: added curr_func(func text, schema_anchor anyelement)

12377 02/23/2014 03:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: removed unneeded regproc(regprocedure), regprocedure(regproc) because these can actually be directly cast to one another, not just via oid

12376 02/23/2014 03:47 PM Aaron Marcuse-Kubitza

schemas/util.sql: added quote_func_call()

12375 02/23/2014 03:22 PM Aaron Marcuse-Kubitza

schemas/util.sql: added regprocedure(text)

12374 02/23/2014 03:11 PM Aaron Marcuse-Kubitza

schemas/util.sql: func2regproc*(): removed func2* so that this has the format of a cast function (which it is)

12373 02/23/2014 03:10 PM Aaron Marcuse-Kubitza

schemas/util.sql: added func2regproc(regprocedure)

12372 02/23/2014 03:08 PM Aaron Marcuse-Kubitza

schemas/util.sql: added func2regprocedure(regproc)

12371 02/23/2014 02:51 PM Aaron Marcuse-Kubitza

schemas/util.sql: added quote_typed()

12370 02/23/2014 01:30 PM Aaron Marcuse-Kubitza

schemas/util.sql: remake_diff_table(): use util.append_comment() instead of util.set_comment() to allow other functions to add comments to the diff table

12369 02/23/2014 01:18 PM Aaron Marcuse-Kubitza

schemas/util.sql: added append_comment(regclass)

12368 02/23/2014 01:00 PM Aaron Marcuse-Kubitza

schemas/util.sql: added comment(oid)

12367 02/23/2014 12:13 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: _traits_08_taxonname_trait_and_value_for_first_5000_records: renamed to _traits_08_taxonname_trait_and_value because this actually includes all the records, not just the first 5000. this uses the new public_validations.rename_query_view() to rename all associated tables and views, including handling truncated names.

12366 02/23/2014 12:08 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: query_relations(), new_query_view_relation_name(): need to take into account the prefix when determining truncation, using the max_prefix_len param

12365 02/23/2014 12:04 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added query_view_relation_max_prefix_len()

12364 02/23/2014 12:03 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: drop_relation(text), rename_relation(text, text): appended _esc to params that should be passed in escaped, and _name to those that shouldn't

12363 02/23/2014 12:00 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: rename_relation(): need quote_ident() around to_

12362 02/23/2014 11:39 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: truncated_prefixed_name_regexp(): need to match the entire string, so that the regexp can be used with util.replace_suffix()

12361 02/23/2014 11:37 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: truncated_prefixed_name_regexp(): need to pass max_prefix_len to util.name_was_truncated() because although the name itself might not have been truncated, it might become truncated once prefixed

12360 02/23/2014 11:32 AM Aaron Marcuse-Kubitza

schemas/util.sql: name_was_truncated(): support max_prefix_len param to determine truncation of something that will be prefixed

12359 02/23/2014 11:22 AM Aaron Marcuse-Kubitza

fix: name_was_truncated(): should use util.namedatalen() instead of hardcoding the value

12358 02/22/2014 08:35 PM Aaron Marcuse-Kubitza

schemas/util.sql: replace_suffix(): support strings that have been truncated (eg. as a table name) due to the prepending of a prefix

12357 02/22/2014 08:32 PM Aaron Marcuse-Kubitza

schemas/util.sql: added truncated_prefixed_name_regexp()

12356 02/22/2014 08:12 PM Aaron Marcuse-Kubitza

schemas/util.sql: added rtrim_n()

12355 02/22/2014 07:58 PM Aaron Marcuse-Kubitza

schemas/util.sql: added name_was_truncated()

12354 02/22/2014 07:56 PM Aaron Marcuse-Kubitza

schemas/util.sql: added namedatalen()

12353 02/22/2014 07:21 PM Aaron Marcuse-Kubitza

schemas/util.sql: drop_relation(regclass), rename_relation(regclass): use util.qual_name() instead of ::text so that the schema qualifier is always included in the debug SQL

12352 02/22/2014 07:18 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added rename_query_view(), which renames all DB objects related to a particular validations query

12351 02/22/2014 07:13 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added new_query_view_relation_name()

12350 02/22/2014 07:11 PM Aaron Marcuse-Kubitza

schemas/util.sql: added replace_suffix()

12349 02/22/2014 06:47 PM Aaron Marcuse-Kubitza

schemas/util.sql: added rename_relation(regclass/text, text)

12348 02/22/2014 06:23 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: drop_relation(): documented that it is actually not idempotent, because the regclass will not be valid after the relation is dropped

12347 02/22/2014 06:21 PM Aaron Marcuse-Kubitza

schemas/util.sql: drop_relation(relation text, type text): put type param first because it is usually constant

12346 02/22/2014 06:12 PM Aaron Marcuse-Kubitza

schemas/util.sql: drop_table(), drop_view(): use drop_relation(relation text, type text)

12345 02/22/2014 06:10 PM Aaron Marcuse-Kubitza

schemas/util.sql: drop_relation(regclass): use simpler drop_relation(relation text, type text)

12344 02/22/2014 06:06 PM Aaron Marcuse-Kubitza

schemas/util.sql: added relation_type(regclass)

12343 02/22/2014 06:04 PM Aaron Marcuse-Kubitza

schemas/util.sql: added drop_relation(relation text, type text)

12342 02/22/2014 06:01 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: drop_relation(): need to pass force param to util.drop_*()

12341 02/22/2014 05:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: added relation_type_char(regclass)

12340 02/22/2014 05:50 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: relation_type(character): must use "char" type for single character, as character actually allows multiple characters. corrected return type.

12339 02/22/2014 05:47 PM Aaron Marcuse-Kubitza

schemas/util.sql: added relation_type(character)

12338 02/22/2014 04:04 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added rm_query_view(), which removes all DB objects related to a particular validations query

12337 02/22/2014 03:49 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: remake_diff_tables(): 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

12336 02/22/2014 03:48 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: query_views(): renamed to query_relations() because this also returns non-views

12335 02/22/2014 03:35 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added public_validations.query_views()

12334 02/22/2014 03:35 PM Aaron Marcuse-Kubitza

schemas/util.sql: schema_matches(): should be IMMUTABLE, not STABLE, because it uses only parameter values

12333 02/22/2014 03:24 PM Aaron Marcuse-Kubitza

schemas/util.sql: added regexp_quote()

12332 02/22/2014 03:18 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: is_table(), is_view(): should be STABLE, not IMMUTABLE, because they reference tables

12331 02/22/2014 02:50 PM Aaron Marcuse-Kubitza

schemas/util.sql: added drop_relation()

12330 02/22/2014 02:41 PM Aaron Marcuse-Kubitza

schemas/util.sql: added is_table()

12329 02/22/2014 02:39 PM Aaron Marcuse-Kubitza

schemas/util.sql: added is_view()

12328 02/22/2014 02:23 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: show_views_like(): need to match the schema exactly, not via regexp like util.show_relations_like() does

12327 02/22/2014 02:14 PM Aaron Marcuse-Kubitza

schemas/util.sql: show_views_like(): use util.show_relations_like()

12326 02/22/2014 02:03 PM Aaron Marcuse-Kubitza

schemas/util.sql: show_views_like(): reversed argument order to match show_relations_like()

12325 02/22/2014 12:32 PM Aaron Marcuse-Kubitza

schemas/util.sql: added show_relations_like()

12324 02/22/2014 12:21 PM Aaron Marcuse-Kubitza

schemas/util.sql: added schema_matches()

12323 02/21/2014 10:19 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: remake_diff_tables(): updated runtime now that row limit has been removed (same, 45 min)

12322 02/20/2014 07:18 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: _traits_07_trait_value_and_units, _traits_08_taxonname_trait_and_value_for_first_5000_records: removed LIMIT to match the input queries

12321 02/20/2014 07:12 PM Aaron Marcuse-Kubitza

schemas/util.sql: materialize_query(): ANALYZE the created table so that it has the correct estimated rowcount

12320 02/20/2014 07:08 PM Aaron Marcuse-Kubitza

schemas/util.sql: added analyze_()

12319 02/20/2014 06:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: remake_diff_tables(): updated bien2_traits runtime (45 min) to include the now-properly-renamed views 6-8

12318 02/20/2014 06:14 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: remake_diff_tables(): documented runtime for bien2_traits (30 min)

12317 02/20/2014 05:52 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: renamed output views to match input views

12316 02/20/2014 04:52 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _traits_01_count_records (output side): documented runtime (4 min)

12315 02/20/2014 04:33 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): resolved ambiguous column references by renaming PL/pgSQL vars and adding table qualifiers

12314 02/20/2014 04:28 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): changed from STABLE to VOLATILE because the search_path can only be set in VOLATILE functions

12313 02/20/2014 04:19 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: source_by_shortname(): can't be declared STRICT because it now has a 2nd param (schema_anchor) which is always NULL

12312 02/20/2014 08:42 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: remake_diff_tables(): can't raise exception at end if had errors, because this would roll back the transaction. instead use new util.raise_error_notice().

12311 02/20/2014 08:41 AM Aaron Marcuse-Kubitza

schemas/util.sql: added raise_error_notice()

12310 02/19/2014 11:59 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Unix: moved into OS folder. Windows: added steps to try for fixing Windows Update.

12309 02/18/2014 07:16 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added remake_diff_tables()

12308 02/18/2014 05:37 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff(text, text): also need to include only different rows when comparing single-row tables

12307 02/17/2014 09:06 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added validation_views()

12306 02/17/2014 08:59 PM Aaron Marcuse-Kubitza

schemas/util.sql: show_views_like(): added predictable ordering

12305 02/17/2014 08:54 PM Aaron Marcuse-Kubitza

schemas/util.sql: added show_views_like()

12304 02/17/2014 08:27 PM Aaron Marcuse-Kubitza

schemas/util.sql: added schema_oid()

12303 02/17/2014 06:45 PM Aaron Marcuse-Kubitza

schemas/util.sql: remake_diff_table(): add comment on the diff table showing how to view it in human-readable form. (the table unfortunately cannot be materialized in human-readable form, because this would create column name collisions between the two sides.)

12302 02/17/2014 06:38 PM Aaron Marcuse-Kubitza

schemas/util.sql: added set_comment()

12301 02/17/2014 06:25 PM Aaron Marcuse-Kubitza

schemas/util.sql: added eval2records()

12300 02/17/2014 05:48 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff(regclass, regclass): display single row tables side-by-side

12299 02/17/2014 05:46 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff(text, text): implemented the single_row feature

12298 02/17/2014 05:40 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff(text, text): added single_row param (not implemented yet, to make reading the svn diff easier). to view this svn diff, it is helpful to use WinMerge, which offers moved block detection (/README.TXT > WinMerge setup).

12297 02/17/2014 04:54 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: remake_diff_table(): util.diff() call: include explicit types on arguments to ensure that the correct diff() variant is used

12296 02/17/2014 04:32 PM Aaron Marcuse-Kubitza

schemas/util.sql: added has_single_row()

12295 02/17/2014 04:08 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: remake_diff_table(): prepend ~ to the type table so that it sorts at the end, away from the main tables

12294 02/17/2014 03:56 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: remake_diff_table(): can't have in_table/out_table inherit from each other, because inheritance also causes the rows of the parent table to be included in the child table. instead, they need to inherit from a common, empty table, as implemented by the new util.remake_diff_table().

12293 02/17/2014 03:55 PM Aaron Marcuse-Kubitza

schemas/util.sql: added remake_diff_table()

12292 02/17/2014 03:51 PM Aaron Marcuse-Kubitza

schemas/util.sql: drop_*(): added force param to use CASCADE mode

12291 02/17/2014 03:28 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff(regclass, regclass): usage: col_type_null must actually be a shared base type of the tables

12290 02/17/2014 03:26 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff(regclass, regclass): usage: text arguments must be cast to regclass to bind the right variant of diff()

12289 02/17/2014 03:24 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff(regclass, regclass): renamed params to *_table because these actually can't be views, since views don't support inheritance

12288 02/17/2014 03:03 PM Aaron Marcuse-Kubitza

schemas/util.sql: added copy_struct()

12287 02/17/2014 02:06 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added remake_diff_table()

12286 02/17/2014 01:58 PM Aaron Marcuse-Kubitza

bugfix: inputs/bien2_traits/validations.sql: _traits_01_count_records: changed column names to match public_validations._traits_01_count_records

12285 02/17/2014 01:54 PM Aaron Marcuse-Kubitza

schemas/util.sql: added inherit()

12284 02/17/2014 01:46 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff(): need to explicitly cast each side to the return type because this does not happen automatically even when an implicit cast is available

12283 02/17/2014 01:32 PM Aaron Marcuse-Kubitza

schemas/util.sql: renamed diff_views(), diff_any() to diff(...) because they are overloads of the same operation