Project

General

Profile

Activity

From 02/04/2014 to 03/05/2014

03/05/2014

11:53 PM Revision 12594: schemas/util.sql: mk_keys_func(): create the keys() function directly from the keys record type, to support creating just a custom keys record type rather than also a custom keys() function (which is fairly complicated to do, thanks to the need to define a separate custom return type)
Aaron Marcuse-Kubitza
01:01 PM Revision 12593: bugfix: schemas/util.sql: relation_type(relation_type_char "char"): need to handle TYPEs as well, because these are also listed in pg_class (and should be deleted by drop_relations_like())
Aaron Marcuse-Kubitza
12:50 PM Revision 12592: schemas/util.sql: added show_types_like()
Aaron Marcuse-Kubitza
12:42 PM Revision 12591: bugfix: schemas/util.sql: functions marked IMMUTABLE: changed to STABLE or VOLATILE where IMMUTABLE would cause preemptive inlining (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Function%20Volatility%20Categories%20**)
Aaron Marcuse-Kubitza
12:25 PM Revision 12590: bugfix: schemas/util.sql: functions marked IMMUTABLE: changed to STABLE or VOLATILE where IMMUTABLE would cause preemptive inlining (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Function%20Volatility%20Categories%20**)
Aaron Marcuse-Kubitza
12:13 PM Revision 12589: schemas/vegbien.sql: locationevent: documented `UPDATE locationevent SET place_visit_id = place_visit_id` runtime (>~1 h)
Aaron Marcuse-Kubitza
07:28 AM Revision 12588: schemas/util.sql: added relation_type(regtype) so drop_relation() would work on TYPEs, too. TYPEs are sometimes used as a function return type linked to a particular table (eg. in the keys() functions), and should be dropped along with the table by util.drop_relations_like().
Aaron Marcuse-Kubitza
07:24 AM Revision 12587: schemas/util.sql: drop_relation(regclass): support any type that has a util.relation_type()
Aaron Marcuse-Kubitza
07:23 AM Revision 12586: fix: schemas/vegbien.sql: _plots_10_count_of_individuals_per_plot_in_each_project: fixed to handle subplots properly, using new locationevent.place_visit_id
Aaron Marcuse-Kubitza
01:02 AM Revision 12585: schemas/vegbien.sql: added place_visit view, analogous to plot but for top-level locationevents. this is needed by the SALVIAS validation queries.
Aaron Marcuse-Kubitza
12:59 AM Revision 12584: schemas/vegbien.sql: locationevent: added locationevent_set_place_visit_id() trigger, analogous to location_set_plot_location_id() but for the locationevent nesting hierarchy. this is needed by the SALVIAS validation queries.
Aaron Marcuse-Kubitza
12:32 AM Revision 12583: fix: schemas/vegbien.sql: location_set_plot_location_id(): removed incorrect comment that this is a pull-forward trigger
Aaron Marcuse-Kubitza

03/04/2014

05:56 PM Revision 12582: bugfix: schemas/vegbien.sql: public_validations.query_view_relation_max_prefix_len(): added values__ prefix
Aaron Marcuse-Kubitza
05:52 PM Revision 12581: bugfix: schemas/util.sql: mk_keys_func(regtype, util.col_cast[]): use `CREATE FUNCTION` instead of `CREATE OR REPLACE FUNCTION` so that the function is only created if it does not exist, to avoid overwriting a custom keys() function
Aaron Marcuse-Kubitza
05:48 PM Revision 12580: schemas/vegbien.sql: public_validations: re-auto-added keys(), values_() functions for all queries
Aaron Marcuse-Kubitza
05:47 PM Revision 12579: bugfix: schemas/util.sql: uses of util.col_cast.col_name: need to wrap in quote_ident()
Aaron Marcuse-Kubitza
05:40 PM Revision 12578: schemas/vegbien.sql: public_validations: re-auto-added keys(), values_() functions for all queries
Aaron Marcuse-Kubitza
05:39 PM Revision 12577: bugfix: schemas/util.sql: mk_keys_func(regtype, util.col_cast[]): use named return type to avoid complicated edge cases with 1-column records, which prevent (values_(...)).* from working correctly
Aaron Marcuse-Kubitza
05:22 PM Revision 12576: schemas/util.sql: added mk_typed_cols_list(col_cast[])
Aaron Marcuse-Kubitza
05:20 PM Revision 12575: schemas/util.sql: added prefixed_name()
Aaron Marcuse-Kubitza
05:18 PM Revision 12574: schemas/util.sql: mk_keys_func(regtype, util.col_cast[]): use util.qual_name() to create the function name, for clarity
Aaron Marcuse-Kubitza
04:56 PM Revision 12573: schemas/vegbien.sql: public_validations: auto-added values_() functions for all queries
Aaron Marcuse-Kubitza
04:53 PM Revision 12572: schemas/util.sql: util.remake_diff_table(): viewing the table in human-readable form: use just the output side's values_() columns, to avoid repeating columns on both sides that are the same and put just the changed columns side-by-side
Aaron Marcuse-Kubitza
04:45 PM Revision 12571: bugfix: schemas/util.sql: mk_keys_func(regtype): values() function: must be called values_() instead because `values` is a keyword
Aaron Marcuse-Kubitza
04:31 PM Revision 12570: schemas/util.sql: mk_keys_func(regtype): also add values() function for use in displaying the diff table
Aaron Marcuse-Kubitza
04:19 PM Revision 12569: schemas/util.sql: mk_keys_func(regtype, col_cast[]): allow changing the name of the generated function
Aaron Marcuse-Kubitza
03:55 PM Revision 12568: schemas/util.sql: `RAISE USING ERRCODE = SQLSTATE, MESSAGE = SQLERRM`: use simpler `RAISE` to rethrow error
Aaron Marcuse-Kubitza
03:53 PM Revision 12567: bugfix: schemas/util.sql: mk_keys_func(regtype, util.col_cast[]): use util.create_if_not_exists() to avoid trying to overwrite a custom keys() function the user has written
Aaron Marcuse-Kubitza
03:49 PM Revision 12566: schemas/vegbien.sql: public_validations: auto-added keys() functions for all queries
Aaron Marcuse-Kubitza
03:41 PM Revision 12565: schemas/util.sql: diff(text, text): automatically create a keys() function for the base type. this avoids the need to create keys() functions manually for the numerous queries that need them.
Aaron Marcuse-Kubitza
03:35 PM Revision 12564: schemas/util.sql: added mk_keys_func(regtype)
Aaron Marcuse-Kubitza
03:34 PM Revision 12563: bugfix: schemas/util.sql: mk_keys_func(regtype, util.col_cast[]): need to handle 1-column records specially, because Postgres does not allow returning a 1-column record when there are OUT params
Aaron Marcuse-Kubitza
03:02 PM Revision 12562: schemas/util.sql: added typed_cols(regtype)
Aaron Marcuse-Kubitza
02:29 PM Revision 12561: schemas/util.sql: added mk_keys_func(regtype, col_cast[])
Aaron Marcuse-Kubitza
02:27 PM Revision 12560: bugfix: schemas/util.sql: raise(): need to use $__BODY1$ in case msg contains $BODY1$ (in SQL)
Aaron Marcuse-Kubitza
02:23 PM Revision 12559: bugfix: schemas/util.sql: mk_out_params(): need COALESCE(..., ) around string_agg()
Aaron Marcuse-Kubitza
02:22 PM Revision 12558: bugfix: schemas/util.sql: eval(): don't declare it STRICT because it should throw an error if you try to execute NULL
Aaron Marcuse-Kubitza
02:20 PM Revision 12557: schemas/vegbien.sql: synced with DB, which reorders ~type tables
Aaron Marcuse-Kubitza
01:59 PM Revision 12556: schemas/util.sql: added mk_out_params()
Aaron Marcuse-Kubitza
01:42 AM Revision 12555: schemas/util.sql: mk_diff_query(): indented left_ table to line up vertically with right_, for easier comparison of the left_/right_ table names
Aaron Marcuse-Kubitza
01:40 AM Revision 12554: schemas/util.sql: mk_diff_query(): removed special handling for CROSS JOIN because this is now handled by diff(text, text) using `FULL JOIN ON true`. this simplification allows mk_diff_query() to contain just the template structure of the FULL JOIN, without _if() calls that decrease readability.
Aaron Marcuse-Kubitza
01:34 AM Revision 12553: schemas/util.sql: diff(text, text): handle the CROSS JOIN special case using `FULL JOIN ON true`, to allow mk_diff_query() to support just a straighforward FULL JOIN. this also ensures that *all* diff queries use the same FULL JOIN template.
Aaron Marcuse-Kubitza

02/28/2014

11:17 PM Revision 12552: bugfix: schemas/vegbien.sql: public_validations: schema comment: also need to re-create keys() functions after running public_validations.rm_all_queries()
Aaron Marcuse-Kubitza
11:13 PM Revision 12551: bugfix: schemas/vegbien.sql: added back keys() matchup functions, which get cascadingly deleted when the queries are re-created to change column names, etc. note that this causes the associated ~type tables to sort before them.
Aaron Marcuse-Kubitza
11:11 PM Revision 12550: schemas/vegbien.sql: added new ~type tables
Aaron Marcuse-Kubitza
10:45 PM Revision 12549: fix: lib/phpPgAdmin.login.php.diff: "For user public_, leave password blank" instruction: moved this to right under the Password field and increased the font size so people would be more likely to see it
Aaron Marcuse-Kubitza
10:28 PM Revision 12548: /Makefile: added separate phppgadmin-Linux target to avoid needing to run the entire postgres-Linux target whenever http://vegbiendev.nceas.ucsb.edu/phppgadmin/ goes down (after some system updates)
Aaron Marcuse-Kubitza
10:03 PM Revision 12547: schemas/vegbien.sql: rm_all_queries(schema): documented this function's unexpected behavior when schema = public_validations (it removes in *all* schemas, not just public_validations). this is because this uses rm_query_view().
Aaron Marcuse-Kubitza
09:49 PM Revision 12546: fix: schemas/vegbien.sql: use plot (which includes only outer plots) instead of location, to match the input queries
Aaron Marcuse-Kubitza
08:15 PM Revision 12545: schemas/vegbien.sql: rm_query_group(): support removing all validations as well as just those with a particular group prefix (and renamed to rm_output_queries())
Aaron Marcuse-Kubitza
07:57 PM Revision 12544: fix: schemas/vegbien.sql: public_validations: schema comment: removed incorrect "" in `SET search_path = "public_validations", pg_catalog;` now that they are no longer auto-added
Aaron Marcuse-Kubitza
07:56 PM Revision 12543: bugfix: schemas/Makefile: `%/install: vegbien.sql`: don't enclose public_validations in "" because this causes a comment that says to search for `SET search_path = public_validations, pg_catalog;` to become mangled
Aaron Marcuse-Kubitza
07:51 PM Revision 12542: schemas/vegbien.sql: synced with DB, which reorders ~type tables
Aaron Marcuse-Kubitza
07:34 PM Revision 12541: fix: schemas/Makefile: moved comment about publishing a schema to %/publish
Aaron Marcuse-Kubitza
05:27 PM Revision 12540: lib/Firefox_bookmarks.reformat.csv: "page's description": changed to "page's own description" to clarify that this is a description provided by the page itself
Aaron Marcuse-Kubitza
05:25 PM Revision 12539: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added links for error reporting levels and how to hide stack traces in psql. SQL: added links for recursive queries, which can be used to traverse hierarchical (parent-pointer) tables.
Aaron Marcuse-Kubitza

02/27/2014

07:56 PM Revision 12538: fix: inputs/SALVIAS/validations.sql: renamed SiteCode to plot_code to match output queries
Aaron Marcuse-Kubitza
07:53 PM Revision 12537: schemas/util.sql: raise_error_notice(): raise a WARNING instead because this is for errors, and rename to raise_error_warning() to match
Aaron Marcuse-Kubitza
07:49 PM Revision 12536: schemas/util.sql: raise_error_notice(): raise a WARNING instead because this is for errors, and rename to raise_error_warning() to match
Aaron Marcuse-Kubitza
07:45 PM Revision 12535: schemas/util.sql: removed no longer used raise_notice(). use util.raise(NOTICE, ...) instead.
Aaron Marcuse-Kubitza
07:41 PM Revision 12534: schemas/util.sql: use util.raise(NOTICE, ...) instead of util.raise_notice()
Aaron Marcuse-Kubitza
07:37 PM Revision 12533: schemas/util.sql: raise(type text, msg text): documented the possible options for the type param
Aaron Marcuse-Kubitza
07:34 PM Revision 12532: fix: schemas/util.sql: raise(): util.eval(): turn off verbose_ mode to avoid printing debug statements about debug statements
Aaron Marcuse-Kubitza
07:32 PM Revision 12531: schemas/util.sql: eval(): added verbose_ option like for eval2set()
Aaron Marcuse-Kubitza
07:28 PM Revision 12530: schemas/util.sql: added raise(type text, msg text)
Aaron Marcuse-Kubitza
07:09 PM Revision 12529: fix: schemas/vegbien.sql: _plots_* validation queries: renamed plot_code columns (with names plotcode, plotCode, SiteCode) to match the input queries (plot_code)
Aaron Marcuse-Kubitza
07:08 PM Revision 12528: fix: schemas/vegbien.sql: added back _traits_* ~type tables
Aaron Marcuse-Kubitza
07:02 PM Revision 12527: fix: schemas/vegbien.sql: _plots_* validation queries: renamed plot_code columns (with names plotcode, plotCode, SiteCode) to match the input queries (plot_code)
Aaron Marcuse-Kubitza
06:58 PM Revision 12526: inputs/SALVIAS/validations.sql: use plot_code instead of plotcode for easier readability
Aaron Marcuse-Kubitza
06:42 PM Revision 12525: fix: schemas/vegbien.sql: rm_all_queries(): all-schemas mode: also remove queries that are only present on the input side, so that the input side can also be re-created from the DDL file
Aaron Marcuse-Kubitza
06:36 PM Revision 12524: fix: schemas/vegbien.sql: rm_all_queries(): documented that this actually *does* remove queries in *all* schemas when schema is NULL, because rm_query_view(public_validations.view) searches *all* schemas
Aaron Marcuse-Kubitza
04:37 PM Revision 12523: schemas/vegbien.sql: top_plot view: renamed to plot, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)
Aaron Marcuse-Kubitza
04:12 PM Revision 12522: schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)
Aaron Marcuse-Kubitza
03:51 PM Revision 12521: schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)
Aaron Marcuse-Kubitza
02:20 PM Revision 12520: schemas/vegbien.sql: source_by_shortname(): documented exact time that the slow query ran for (5013s = ~1.5 hours)
Aaron Marcuse-Kubitza
02:07 PM Revision 12519: schemas/vegbien.sql: public_validations: schema comment: documented how to sync the queries with schemas/vegbien.sql
Aaron Marcuse-Kubitza
02:05 PM Revision 12518: schemas/vegbien.sql: public_validations.rm_all_queries(): when called with no args, operate on public_validations instead of all schemas, since this is the more common use case (replacing just the output queries, not both input and output)
Aaron Marcuse-Kubitza
01:49 PM Revision 12517: schemas/vegbien.sql: rm_query_group(): documented that this only removes validations *output* queries (in public_validations), as it is designed for use in updating all output queries at once from the testing DB
Aaron Marcuse-Kubitza
01:27 PM Revision 12516: bugfix: *.sql: public.source_by_shortname(): need to wrap it in a nested SELECT because Postgres incorrectly does not constant-fold (inline) it, leading to a slowdown when it is therefore run many times. this is done using the steps at wiki.vegpath.org/Postgres_queries#wrap-function-call-in-nested-SELECT .
Aaron Marcuse-Kubitza
12:43 PM Revision 12515: schemas/vegbien.sql: source_by_shortname(): documented that it *must* be run as a nested SELECT, because otherwise Postgres will not inline it. not inlining causes the query to be run for *each* row in a table of potentially millions, and creates a significant slowdown (eg. >1.5 hours for SALVIAS._plots_06_list_of_plots_with_stem_measurements)
Aaron Marcuse-Kubitza
07:59 AM Revision 12514: schemas/util.sql: eval2val(): made it STABLE so that functions that use it can themselves be inlined. (Postgres apparently ignores the STABLE qualifier, without warning, if the function contains any VOLATILE statements.)
Aaron Marcuse-Kubitza
06:51 AM Revision 12513: fix: schemas/vegbien.sql: source_by_shortname(): needs to be declared STABLE so it can be constant-folded and only run once per query. (it had previously been VOLATILE because of constraints imposed on functions that run `SET LOCAL search_path`.)
Aaron Marcuse-Kubitza
01:11 AM Revision 12512: fix: schemas/vegbien.sql: location: added index on top_plot
Aaron Marcuse-Kubitza
01:11 AM Revision 12511: fix: schemas/vegbien.sql: location: added index on top_plot
Aaron Marcuse-Kubitza
01:06 AM Revision 12510: fix: schemas/vegbien.sql: _plots_06_list_of_plots_with_stem_measurements: changed columns to match input query
Aaron Marcuse-Kubitza
01:04 AM Revision 12509: schemas/vegbien.sql: added more ~type tables for plots queries
Aaron Marcuse-Kubitza

02/26/2014

11:58 PM Revision 12508: fix: inputs/SALVIAS/validations.sql: plotMetadata.SiteCode: need to match types with the output query column
Aaron Marcuse-Kubitza
11:44 PM Revision 12507: schemas/vegbien.sql: added public_validations.rm_all_queries(schema), which removes all validations queries in a schema, or in all schemas (useful when recreating validations queries from the DDL export file)
Aaron Marcuse-Kubitza
11:29 PM Revision 12506: schemas/util.sql: validation_views(): moved filtering out of *_validations schemas to validatable_datasources() so that calling this function with no args gives the validation views in *all* schemas as one would expect
Aaron Marcuse-Kubitza
10:58 PM Revision 12505: schemas/util.sql: query_relations(): support passing in an input query instead of an output query, which will remove only in the datasource's schema. (note that it was not clear that passing in an *input-side* query was not previously supported.)
Aaron Marcuse-Kubitza
10:50 PM Revision 12504: schemas/util.sql: added schema_regexp(regclass)
Aaron Marcuse-Kubitza
10:30 PM Revision 12503: schemas/vegbien.sql: schema_anchor: clarified that this identifies this function's schema (for use in locating helper functions), but is not necessarily the schema operated on, as the comment implied
Aaron Marcuse-Kubitza
10:05 PM Revision 12502: schemas/util.sql: drop_relations_like(): use util.schema_regexp()
Aaron Marcuse-Kubitza
10:02 PM Revision 12501: schemas/util.sql: added schema_regexp(schema_anchor)
Aaron Marcuse-Kubitza
01:16 PM Revision 12500: fix: schemas/vegbien.sql: _plots_04_count_of_plots_in_each_project_in_this_source: count *top-level* plots to match the input query
Aaron Marcuse-Kubitza
12:29 PM Revision 12499: schemas/vegbien.sql: remake_diff_table(): instructions for how to regenerate the diff table: put these at the beginning of the table comment instead of the end, because they are the most important info about the table that a user needs to know
Aaron Marcuse-Kubitza
11:58 AM Revision 12498: schemas/util.sql: diff(text, text): documented how to write a custom keys() function to match up rows using a subset of the columns (including a sample keys() function template)
Aaron Marcuse-Kubitza
11:37 AM Revision 12497: schemas/vegbien.sql: replaced custom %== operators with much simpler custom keys() functions. this avoids both the need to write out an = comparison for each field, and especially, also the need to write both an operator *and* a function implementing that operator.
Aaron Marcuse-Kubitza
10:42 AM Revision 12496: bugfix: schemas/util.sql: diff(text, text): in the %== comparison, it turns out you *do* need to cast the values to the *same* base type, *even though* this is optional when using a custom %==
Aaron Marcuse-Kubitza

02/25/2014

11:51 PM Revision 12495: schemas/util.sql: remake_diff_table(): prepend the "view this table in human-readable form" comment instead of appending because it is more important than the "contents generated from" comment previously added
Aaron Marcuse-Kubitza
11:49 PM Revision 12494: schemas/util.sql: added prepend_comment()
Aaron Marcuse-Kubitza
11:39 PM Revision 12493: schemas/util.sql: removed no longer used mk_set_search_path(VARIADIC schemas text[]). use mk_search_path() instead.
Aaron Marcuse-Kubitza
11:36 PM Revision 12492: schemas/util.sql, vegbien.sql: comment about "function option search_path": don't include `mk_set_search_path()` since that is no longer used
Aaron Marcuse-Kubitza
11:35 PM Revision 12491: schemas/util.sql: diff(text, text): always use the schema of col_type_null (the common base type) as the search_path, since any custom %== operator for it will always be in the same schema as it
Aaron Marcuse-Kubitza
11:28 PM Revision 12490: schemas/util.sql: use_own_schema(): renamed to use_schema() because this can be used for any type-linked schema
Aaron Marcuse-Kubitza
11:23 PM Revision 12489: bugfix: rematerialize_out_view(): set_search_path() does not take the same arguments as mk_set_search_path() did, so need to use mk_search_path() instead
Aaron Marcuse-Kubitza
11:19 PM Revision 12488: schemas/util.sql: use_own_schema(): auto-append util to the search_path to enable use of util operators
Aaron Marcuse-Kubitza
11:11 PM Revision 12487: schemas/util.sql: mk_set_search_path(): no need to debug_print_return_value() anymore because functions now use set_search_path() (or something that calls it), which debug-prints the statement (`EXECUTE util.mk_set_search_path()` did not)
Aaron Marcuse-Kubitza
11:06 PM Revision 12486: schemas/util.sql: mk_search_path(), mk_set_search_path(text...): auto-append util to the search_path to enable use of util operators
Aaron Marcuse-Kubitza
10:49 PM Revision 12485: schemas/util.sql: removed no longer used mk_use_own_schema(). use util.use_own_schema() instead.
Aaron Marcuse-Kubitza
10:48 PM Revision 12484: schemas/util.sql, vegbien.sql: use util.use_own_schema()/util.set_search_path() instead of EXECUTE util.mk_use_own_schema()/util.mk_set_search_path()
Aaron Marcuse-Kubitza
10:42 PM Revision 12483: schemas/util.sql: added use_own_schema()
Aaron Marcuse-Kubitza
10:40 PM Revision 12482: schemas/util.sql: added set_search_path()
Aaron Marcuse-Kubitza
10:36 PM Revision 12481: schemas/util.sql: runnable_sql(): don't output search_path before a SET statement
Aaron Marcuse-Kubitza
10:31 PM Revision 12480: schemas/util.sql: added is_set_stmt()
Aaron Marcuse-Kubitza
09:28 PM Revision 12479: schemas/util.sql: diff(text, text): use mk_diff_query()'s new cols param to avoid a nested SELECT
Aaron Marcuse-Kubitza
09:17 PM Revision 12478: schemas/util.sql: mk_diff_query(): parameterized the customizable parts of the query, to allow them to be replaced with their EXPLAIN expansion (which is what we ultimately want, so that the query does not refer to any internal tables or views)
Aaron Marcuse-Kubitza
09:02 PM Revision 12477: schemas/util.sql: diff(text, text): use util.mk_diff_query(). this splits the complex query-generation code apart from the query-execution code.
Aaron Marcuse-Kubitza
08:51 PM Revision 12476: bugfix: schemas/util.sql: undid r12472 because the command needed to limit the effects of any `SET LOCAL search_path` to the current function will unfortunately also clear any existing search_path, which may be needed for the eval query to execute
Aaron Marcuse-Kubitza
08:25 PM Revision 12475: schemas/util.sql: added mk_diff_query()
Aaron Marcuse-Kubitza
08:13 PM Revision 12474: schemas/util.sql: debug_print_sql(): use runnable_sql()
Aaron Marcuse-Kubitza
08:12 PM Revision 12473: schemas/util.sql: added runnable_sql()
Aaron Marcuse-Kubitza
08:07 PM Revision 12472: fix: schemas/util.sql: eval2*(): added search_path function option in order to limit the effects of any `SET LOCAL search_path` in the invoked query to the current function. however, plain eval() is not changed because it is often used to execute a `SET LOCAL search_path` in the calling function.
Aaron Marcuse-Kubitza
06:03 PM Revision 12471: schemas/util.sql: diff(text, text): removed unnecessary casts to the base type in the join condition and the WHERE filter. these had been presumed necessary due to errors, but the errors turned out to be caused by the operator not being in the search_path. note that the casts in the columns list are still needed, as described in the associated comment.
Aaron Marcuse-Kubitza
05:40 PM Revision 12470: schemas/util.sql: materialize_query(): add a comment on the table with the query it was generated from
Aaron Marcuse-Kubitza
05:39 PM Revision 12469: schemas/util.sql: debug_print_sql(): util.mk_set_search_path(): use for_printing := true to comment out LOCAL
Aaron Marcuse-Kubitza
04:11 PM Revision 12468: schemas/util.sql: mk_set_search_path(text): include LOCAL commented out, because the user might want to run it with another statement *as a single command*, in which case it would be useful because they will be in the same transaction (http://www.postgresql.org/docs/9.3/static/sql-set.html#AEN81154)
Aaron Marcuse-Kubitza
04:09 PM Revision 12467: schemas/util.sql: mk_set_search_path(): added for_printing option like for mk_set_search_path(text)
Aaron Marcuse-Kubitza
04:04 PM Revision 12466: schemas/util.sql: mk_set_search_path(): support creating a SET search_path statement for display as well, which would exclude LOCAL because it doesn't work as a standalone command (http://www.postgresql.org/docs/9.3/static/sql-set.html#AEN81154)
Aaron Marcuse-Kubitza
02:48 PM Revision 12465: schemas/util.sql: debug_print_sql(): include the search_path in case the query contains search_path-dependent elements (such as operators)
Aaron Marcuse-Kubitza
02:45 PM Revision 12464: schemas/util.sql: util.explain2notice_msg(): add newline before and after to visually separate it from other debug info
Aaron Marcuse-Kubitza
02:30 PM Revision 12463: schemas/util.sql: added mk_set_search_path() (which uses the current search_path)
Aaron Marcuse-Kubitza
02:08 PM Revision 12462: schemas/util.sql: diff(text, text): in the outputted FULL JOIN query, documented that you should refer to the EXPLAIN output for the expansion of %==
Aaron Marcuse-Kubitza
01:54 PM Revision 12461: bugfix: schemas/util.sql: first_word(): ignore leading whitespace: need to use util.ltrim_nl(), as ltrim() only removes spaces
Aaron Marcuse-Kubitza
01:46 PM Revision 12460: bugfix: schemas/util.sql: first_word(): need to ignore leading whitespace. this applies to many of our queries, which have a leading newline.
Aaron Marcuse-Kubitza
01:44 PM Revision 12459: schemas/util.sql: explain(): don't debug-print the EXPLAIN, to avoid cluttering up the debug output
Aaron Marcuse-Kubitza
01:41 PM Revision 12458: schemas/util.sql: eval2set(): make debug-printing optional, for use with internal statements
Aaron Marcuse-Kubitza
01:28 PM Revision 12457: schemas/util.sql: added is_explain()
Aaron Marcuse-Kubitza
01:25 PM Revision 12456: fix: schemas/util.sql: diff(text, text): FULL JOIN SELECT statement: don't put a comment at the very beginning, because this prevents it from being autoexplained (this is the query we particularly want EXPLAIN output for)
Aaron Marcuse-Kubitza
01:22 PM Revision 12455: fix: schemas/util.sql: debug_print_sql(): only surround EXPLAIN output with newlines if there is any
Aaron Marcuse-Kubitza
01:19 PM Revision 12454: fix: schemas/util.sql: debug_print_sql(): need newline before and after EXPLAIN output to visually separate it from other debug info
Aaron Marcuse-Kubitza
01:06 PM Revision 12453: schemas/util.sql: util.debug_print_sql(): include the EXPLAIN output of applicable queries, for easier query plan debugging (just like lib/sql.py's db.autoexplain)
Aaron Marcuse-Kubitza
01:02 PM Revision 12452: schemas/util.sql: added explain2notice_msg_if_can()
Aaron Marcuse-Kubitza
12:57 PM Revision 12451: schemas/util.sql: added is_explainable(sql)
Aaron Marcuse-Kubitza
12:55 PM Revision 12450: schemas/util.sql: added first_word()
Aaron Marcuse-Kubitza
12:25 PM Revision 12449: schemas/util.sql: explain2notice(): use util.raise_notice()
Aaron Marcuse-Kubitza
12:23 PM Revision 12448: schemas/util.sql: explain2notice(): added helper function explain2notice_msg() which can also be used individually
Aaron Marcuse-Kubitza
12:21 PM Revision 12447: fix: schemas/util.sql: schema comment: noted that avoiding use of STRICT also makes functions *much* easier to troubleshoot, because they won't mysteriously do nothing if called with only NULL arguments, even when you have added debug-print statements
Aaron Marcuse-Kubitza
12:19 PM Revision 12446: schemas/util.sql, vegbien.sql: do not declare *any* SQL-language functions as STRICT, because this prevents them from being inlined (as documented in the util schema comment). the STRICT qualifier has been preserved where its behavior is necessary, rather than just used for optimization.
Aaron Marcuse-Kubitza
12:09 PM Revision 12445: fix: schemas/util.sql: schema comment: indicate that *all* SQL-language functions should never be declared STRICT, not just IMMUTABLE ones, since inlining is not limited to IMMUTABLE (or STABLE) functions (although constant folding is)
Aaron Marcuse-Kubitza
12:07 PM Revision 12444: 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
Aaron Marcuse-Kubitza
11:56 AM Revision 12443: 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**)
Aaron Marcuse-Kubitza
11:49 AM Revision 12442: 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)
Aaron Marcuse-Kubitza
11:37 AM Revision 12441: 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)
Aaron Marcuse-Kubitza
11:23 AM Revision 12440: 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.
Aaron Marcuse-Kubitza
10:55 AM Revision 12439: fix: schemas/util.sql: diff(text, text): use util.typeof() instead of pg_typeof() so the outputted query is runnable in any search_path
Aaron Marcuse-Kubitza
10:50 AM Revision 12438: schemas/util.sql: added typeof(), which unlike pg_typeof() uses util.qual_name() to create a search_path-independent name
Aaron Marcuse-Kubitza
10:33 AM Revision 12437: fix: schemas/util.sql: quote_typed(): schema-qualify the type so the expression does not depend on the search_path
Aaron Marcuse-Kubitza
10:31 AM Revision 12436: 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
Aaron Marcuse-Kubitza
10:29 AM Revision 12435: schemas/vegbien.sql: synced from DB, which changes the order of the ~type tables
Aaron Marcuse-Kubitza
10:12 AM Revision 12434: schemas/util.sql: diff(regclass, regclass): support custom %== by including the col_type_null's schema in the search_path
Aaron Marcuse-Kubitza
10:07 AM Revision 12433: schemas/util.sql: debug_print_return_value(): don't '-encode the value by default, because text values usually look better without the '-escaping
Aaron Marcuse-Kubitza
09:55 AM Revision 12432: bugfix: schemas/util.sql: mk_set_search_path(): debug_print_return_value() needs to be on mk_set_search_path(text), not mk_search_path(VARIADIC text[])
Aaron Marcuse-Kubitza
09:45 AM Revision 12431: schemas/util.sql: mk_search_path(): use debug_print_return_value() because this function is used with EXECUTE rather than util.eval() (in order to affect the calling function), so the search_path would not otherwise be printed
Aaron Marcuse-Kubitza
09:39 AM Revision 12430: schemas/util.sql: added debug_print_return_value()
Aaron Marcuse-Kubitza
09:34 AM Revision 12429: schemas/util.sql: diff(text, text): support custom search_path because custom %== operators are usually not in the util schema
Aaron Marcuse-Kubitza
09:28 AM Revision 12428: schemas/util.sql: diff(text, text): renamed IN params to be different from OUT params to support LANGUAGE plpgsql
Aaron Marcuse-Kubitza
09:04 AM Revision 12427: bugfix: schemas/util.sql: diff(*): changed from STABLE to VOLATILE because these functions create tables
Aaron Marcuse-Kubitza
07:56 AM Revision 12426: /README.TXT: use full hostname for jupiter so the commands work outside of the NCEAS network as well
Aaron Marcuse-Kubitza
07:52 AM Revision 12425: schemas/vegbien.sql: _plots_04_count_of_plots_in_each_project_in_this_source: added operator %== to match the rows by project_name
Aaron Marcuse-Kubitza
07:42 AM Revision 12424: bugfix: schemas/util.sql: diff(text, text) and types that use its custom FULL JOIN matching: need to use separate operator %== for determining which records to put on the same row, so that the = filter for identical rows only excludes rows that are actually the same, not all rows with the same *keys* (which would usually remove all rows)
Aaron Marcuse-Kubitza
07:21 AM Revision 12423: schemas/util.sql: added operator %== , which returns whether the map-keys of the compared values are the same
Aaron Marcuse-Kubitza
07:14 AM Revision 12422: schemas/vegbien.sql: synced from DB, which changes the order of the ~type tables
Aaron Marcuse-Kubitza
12:24 AM Revision 12421: schemas/vegbien.sql: _plots_02_list_of_project_names: added = operator that causes FULL JOIN to only use some columns, so that rows for the same label column are put on the same row in the diff table
Aaron Marcuse-Kubitza
12:16 AM Revision 12420: schemas/util.sql: diff(): support custom = operator for the table type (to FULL JOIN on only some columns). this requires casting to the base type, to avoid an ambiguity with the default = operator for record.
Aaron Marcuse-Kubitza

02/24/2014

11:18 PM Revision 12419: schemas/util.sql: remake_diff_table(): use util.quote_typed() instead of hardcoding the type
Aaron Marcuse-Kubitza
11:17 PM Revision 12418: fix: inputs/SALVIAS/validations.sql: _plots_02_list_of_project_names: altered column aliases to match output query
Aaron Marcuse-Kubitza
10:51 PM Revision 12417: fix: inputs/SALVIAS/validations.sql: _plots_02_list_of_project_names: altered column aliases to match output query
Aaron Marcuse-Kubitza
05:16 PM Revision 12416: fix: schemas/vegbien.sql: rm_query_group(): schemas/vegbien.sql: util.drop_relations_like(): also need to drop ~type tables, so that they will be re-created for the new queries of that group
Aaron Marcuse-Kubitza
04:52 PM Revision 12415: schemas/vegbien.sql: added rm_query_group(), which removes all validations queries with a particular group prefix
Aaron Marcuse-Kubitza
04:50 PM Revision 12414: schemas/vegbien.sql: generated ~type for _plots_04_count_of_plots_in_each_project_in_this_source
Aaron Marcuse-Kubitza
04:43 PM Revision 12413: schemas/util.sql: added drop_relations_like()
Aaron Marcuse-Kubitza
03:26 PM Revision 12412: fix: schemas/vegbien.sql: public_validations._plots_* that use projectname: re-alias to project_name to match input queries. (reexporting apparently changes the relative order of the ~type tables.)
Aaron Marcuse-Kubitza
02:34 PM Revision 12411: fix: schemas/vegbien.sql: _plots_03_count_of_all_plots_in_this_source: use top_plot instead of location because the corresponding input query includes just the top-level plots
Aaron Marcuse-Kubitza
02:33 PM Revision 12410: schemas/vegbien.sql: added ~type tables for plots queries that are able to be run successfully
Aaron Marcuse-Kubitza
11:39 AM Revision 12409: web/links/index.htm: updated to Firefox bookmarks: Roundtable: virtual collaboration: annotated the linked pages
Aaron Marcuse-Kubitza
11:24 AM Revision 12408: web/links/index.htm: updated to Firefox bookmarks: Roundtable: added materials for virtual collaboration roundtable. Mac: added steps for customizing screen saver security settings beyond the options supported in the UI.
Aaron Marcuse-Kubitza
08:58 AM Revision 12407: inputs/SALVIAS/validations.sql: added Brad's comments from validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql
Aaron Marcuse-Kubitza
08:53 AM Revision 12406: added inputs/SALVIAS/validations*.sql
Aaron Marcuse-Kubitza
08:50 AM Revision 12405: bugfix: lib/common.Makefile: `svn add`: need to run with --force because the new version of svn in the latest Mac upgrade errors if the file is already under version control
Aaron Marcuse-Kubitza
08:37 AM Revision 12404: fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: renamed truncated views to match the output queries
Aaron Marcuse-Kubitza
12:30 AM Revision 12403: bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses
Aaron Marcuse-Kubitza
12:28 AM Revision 12402: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: removed `LIMIT 10` to match output queries
Aaron Marcuse-Kubitza
12:26 AM Revision 12401: fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: updated table names to match our renamings
Aaron Marcuse-Kubitza
12:25 AM Revision 12400: schemas/vegbien.sql: public_validations.remake_diff_table(): put the type table in the public_validations schema to avoid cluttering up the datasource schema with internal tables
Aaron Marcuse-Kubitza
12:24 AM Revision 12399: schemas/vegbien.sql: synced to DB, which changes the sort order (due to system update?)
Aaron Marcuse-Kubitza
12:21 AM Revision 12398: bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses
Aaron Marcuse-Kubitza
12:16 AM Revision 12397: added validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql, modified from bien3_validations_salvias_db_original.sql using the steps at http://wiki.vegpath.org/Aggregating_validations_refactoring
Aaron Marcuse-Kubitza

02/23/2014

11:57 PM Revision 12396: fix: /README.TXT: use exact ssh command needed to connect to vegbiendev/jupiter (eg. `ssh -t vegbiendev.nceas.ucsb.edu exec sudo su - aaronmk`) instead of vaguely referring to "on vegbiendev"/"on jupiter"
Aaron Marcuse-Kubitza
11:28 PM Revision 12395: /README.TXT: Full database import: screen: run `unset TMOUT` first because it is most important, now that the remote servers have a TMOUT set for extra security
Aaron Marcuse-Kubitza
08:29 PM Revision 12394: bin/psql_verbose_vegbien: use \\ instead of \ inside '' because this is sh, not bash
Aaron Marcuse-Kubitza
08:26 PM Revision 12393: bin/psql_verbose_vegbien: changed prep-statement order to match lib/sh/db.sh psql()
Aaron Marcuse-Kubitza
08:26 PM Revision 12392: bin/psql_verbose_vegbien: use `\set VERBOSITY terse` to hide stack traces/DETAIL sections of error messages, like in lib/sh/db.sh psql()
Aaron Marcuse-Kubitza
08:11 PM Revision 12391: bin/make_analytical_db: added `public_validations.remake_diff_tables()`
Aaron Marcuse-Kubitza
08:03 PM Task #871 (New): grant bien_read access to validation result tables
Aaron Marcuse-Kubitza
08:02 PM Task #870 (New): grant bien_read access to publishable staging tables
Aaron Marcuse-Kubitza
07:57 PM Task #501 (Resolved): find out which datasources won't allow their data to be publicly accessible
Aaron Marcuse-Kubitza
07:44 PM Revision 12390: fix: schemas/vegbien.sql: public_validations.rename_query_view(): fixed usage
Aaron Marcuse-Kubitza
07:43 PM Revision 12389: schemas/vegbien.sql: added remake_diff_tables() with no args, which remakes all validatable datasources
Aaron Marcuse-Kubitza
07:40 PM Revision 12388: schemas/vegbien.sql: added validatable_datasources()
Aaron Marcuse-Kubitza
07:36 PM Revision 12387: schemas/vegbien.sql: added validatable_datasources()
Aaron Marcuse-Kubitza
07:31 PM Revision 12386: schemas/vegbien.sql: validation_views(): allow leaving out schema to match all datasources
Aaron Marcuse-Kubitza
07:23 PM Revision 12385: schemas/util.sql: show_views_like(): take a schema regexp like util.show_relations_like(), to allow matching views in all schemas
Aaron Marcuse-Kubitza
07:19 PM Revision 12384: schemas/util.sql: added str_equality_regexp(literal text)
Aaron Marcuse-Kubitza
07:01 PM Revision 12383: schemas/vegbien.sql: public_validations.remake_diff_table(): put the type table in the public_validations schema to avoid cluttering up the datasource schema with internal tables
Aaron Marcuse-Kubitza
06:50 PM Revision 12382: 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.
Aaron Marcuse-Kubitza
06:00 PM Revision 12381: /README.TXT: to back up the version history: added steps to sync git to the local machine
Aaron Marcuse-Kubitza
05:55 PM Revision 12380: added validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_complete.sql from Brad's e-mail
Aaron Marcuse-Kubitza
05:32 PM Revision 12379: 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
Aaron Marcuse-Kubitza
05:08 PM Revision 12378: schemas/util.sql: added curr_func(func text, schema_anchor anyelement)
Aaron Marcuse-Kubitza
03:50 PM Revision 12377: schemas/util.sql: removed unneeded regproc(regprocedure), regprocedure(regproc) because these can actually be directly cast to one another, not just via oid
Aaron Marcuse-Kubitza
03:47 PM Revision 12376: schemas/util.sql: added quote_func_call()
Aaron Marcuse-Kubitza
03:22 PM Revision 12375: schemas/util.sql: added regprocedure(text)
Aaron Marcuse-Kubitza
03:11 PM Revision 12374: schemas/util.sql: func2regproc*(): removed func2* so that this has the format of a cast function (which it is)
Aaron Marcuse-Kubitza
03:10 PM Revision 12373: schemas/util.sql: added func2regproc(regprocedure)
Aaron Marcuse-Kubitza
03:08 PM Revision 12372: schemas/util.sql: added func2regprocedure(regproc)
Aaron Marcuse-Kubitza
02:51 PM Revision 12371: schemas/util.sql: added quote_typed()
Aaron Marcuse-Kubitza
01:30 PM Revision 12370: 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
Aaron Marcuse-Kubitza
01:18 PM Revision 12369: schemas/util.sql: added append_comment(regclass)
Aaron Marcuse-Kubitza
01:00 PM Revision 12368: schemas/util.sql: added comment(oid)
Aaron Marcuse-Kubitza
12:13 PM Revision 12367: 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.
Aaron Marcuse-Kubitza
12:08 PM Revision 12366: 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
Aaron Marcuse-Kubitza
12:04 PM Revision 12365: schemas/vegbien.sql: added query_view_relation_max_prefix_len()
Aaron Marcuse-Kubitza
12:03 PM Revision 12364: 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
Aaron Marcuse-Kubitza
12:00 PM Revision 12363: bugfix: schemas/util.sql: rename_relation(): need quote_ident() around to_
Aaron Marcuse-Kubitza
11:39 AM Revision 12362: 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()
Aaron Marcuse-Kubitza
11:37 AM Revision 12361: 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
Aaron Marcuse-Kubitza
11:32 AM Revision 12360: schemas/util.sql: name_was_truncated(): support max_prefix_len param to determine truncation of something that will be prefixed
Aaron Marcuse-Kubitza
11:22 AM Revision 12359: fix: name_was_truncated(): should use util.namedatalen() instead of hardcoding the value
Aaron Marcuse-Kubitza

02/22/2014

08:35 PM Revision 12358: schemas/util.sql: replace_suffix(): support strings that have been truncated (eg. as a table name) due to the prepending of a prefix
Aaron Marcuse-Kubitza
08:32 PM Revision 12357: schemas/util.sql: added truncated_prefixed_name_regexp()
Aaron Marcuse-Kubitza
08:12 PM Revision 12356: schemas/util.sql: added rtrim_n()
Aaron Marcuse-Kubitza
07:58 PM Revision 12355: schemas/util.sql: added name_was_truncated()
Aaron Marcuse-Kubitza
07:56 PM Revision 12354: schemas/util.sql: added namedatalen()
Aaron Marcuse-Kubitza
07:21 PM Revision 12353: 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
Aaron Marcuse-Kubitza
07:18 PM Revision 12352: schemas/vegbien.sql: added rename_query_view(), which renames all DB objects related to a particular validations query
Aaron Marcuse-Kubitza
07:13 PM Revision 12351: schemas/vegbien.sql: added new_query_view_relation_name()
Aaron Marcuse-Kubitza
07:11 PM Revision 12350: schemas/util.sql: added replace_suffix()
Aaron Marcuse-Kubitza
06:47 PM Revision 12349: schemas/util.sql: added rename_relation(regclass/text, text)
Aaron Marcuse-Kubitza
06:23 PM Revision 12348: 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
Aaron Marcuse-Kubitza
06:21 PM Revision 12347: schemas/util.sql: drop_relation(relation text, type text): put type param first because it is usually constant
Aaron Marcuse-Kubitza
06:12 PM Revision 12346: schemas/util.sql: drop_table(), drop_view(): use drop_relation(relation text, type text)
Aaron Marcuse-Kubitza
06:10 PM Revision 12345: schemas/util.sql: drop_relation(regclass): use simpler drop_relation(relation text, type text)
Aaron Marcuse-Kubitza
06:06 PM Revision 12344: schemas/util.sql: added relation_type(regclass)
Aaron Marcuse-Kubitza
06:04 PM Revision 12343: schemas/util.sql: added drop_relation(relation text, type text)
Aaron Marcuse-Kubitza
06:01 PM Revision 12342: bugfix: schemas/util.sql: drop_relation(): need to pass force param to util.drop_*()
Aaron Marcuse-Kubitza
05:50 PM Revision 12341: schemas/util.sql: added relation_type_char(regclass)
Aaron Marcuse-Kubitza
05:50 PM Revision 12340: bugfix: schemas/util.sql: relation_type(character): must use "char" type for single character, as character actually allows multiple characters. corrected return type.
Aaron Marcuse-Kubitza
05:47 PM Revision 12339: schemas/util.sql: added relation_type(character)
Aaron Marcuse-Kubitza
04:04 PM Revision 12338: schemas/vegbien.sql: added rm_query_view(), which removes all DB objects related to a particular validations query
Aaron Marcuse-Kubitza
03:49 PM Revision 12337: 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
Aaron Marcuse-Kubitza
03:48 PM Revision 12336: fix: schemas/vegbien.sql: query_views(): renamed to query_relations() because this also returns non-views
Aaron Marcuse-Kubitza
03:35 PM Revision 12335: schemas/vegbien.sql: added public_validations.query_views()
Aaron Marcuse-Kubitza
03:35 PM Revision 12334: schemas/util.sql: schema_matches(): should be IMMUTABLE, not STABLE, because it uses only parameter values
Aaron Marcuse-Kubitza
03:24 PM Revision 12333: schemas/util.sql: added regexp_quote()
Aaron Marcuse-Kubitza
03:18 PM Revision 12332: fix: schemas/util.sql: is_table(), is_view(): should be STABLE, not IMMUTABLE, because they reference tables
Aaron Marcuse-Kubitza
02:50 PM Revision 12331: schemas/util.sql: added drop_relation()
Aaron Marcuse-Kubitza
02:41 PM Revision 12330: schemas/util.sql: added is_table()
Aaron Marcuse-Kubitza
02:39 PM Revision 12329: schemas/util.sql: added is_view()
Aaron Marcuse-Kubitza
02:23 PM Revision 12328: bugfix: schemas/util.sql: show_views_like(): need to match the schema exactly, not via regexp like util.show_relations_like() does
Aaron Marcuse-Kubitza
02:14 PM Revision 12327: schemas/util.sql: show_views_like(): use util.show_relations_like()
Aaron Marcuse-Kubitza
02:03 PM Revision 12326: schemas/util.sql: show_views_like(): reversed argument order to match show_relations_like()
Aaron Marcuse-Kubitza
12:32 PM Revision 12325: schemas/util.sql: added show_relations_like()
Aaron Marcuse-Kubitza
12:21 PM Revision 12324: schemas/util.sql: added schema_matches()
Aaron Marcuse-Kubitza

02/21/2014

10:19 PM Revision 12323: schemas/vegbien.sql: remake_diff_tables(): updated runtime now that row limit has been removed (same, 45 min)
Aaron Marcuse-Kubitza

02/20/2014

07:18 PM Revision 12322: 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
Aaron Marcuse-Kubitza
07:12 PM Revision 12321: schemas/util.sql: materialize_query(): ANALYZE the created table so that it has the correct estimated rowcount
Aaron Marcuse-Kubitza
07:08 PM Revision 12320: schemas/util.sql: added analyze_()
Aaron Marcuse-Kubitza
06:49 PM Revision 12319: schemas/vegbien.sql: remake_diff_tables(): updated bien2_traits runtime (45 min) to include the now-properly-renamed views 6-8
Aaron Marcuse-Kubitza
06:14 PM Revision 12318: schemas/vegbien.sql: remake_diff_tables(): documented runtime for bien2_traits (30 min)
Aaron Marcuse-Kubitza
05:52 PM Revision 12317: fix: schemas/vegbien.sql: renamed output views to match input views
Aaron Marcuse-Kubitza
04:52 PM Revision 12316: schemas/vegbien.sql: _traits_01_count_records (output side): documented runtime (4 min)
Aaron Marcuse-Kubitza
04:44 PM Task #869 (New): enable schema changes to be made on vegbiendev rather than the development machine
h3. fix
allow refactoring the live public schema the same way as the live TNRS cache:
# rename constant tables ...
Aaron Marcuse-Kubitza
04:33 PM Revision 12315: bugfix: schemas/vegbien.sql: source_by_shortname(): resolved ambiguous column references by renaming PL/pgSQL vars and adding table qualifiers
Aaron Marcuse-Kubitza
04:28 PM Revision 12314: bugfix: schemas/vegbien.sql: source_by_shortname(): changed from STABLE to VOLATILE because the search_path can only be set in VOLATILE functions
Aaron Marcuse-Kubitza
04:19 PM Revision 12313: 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
Aaron Marcuse-Kubitza
08:42 AM Revision 12312: 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().
Aaron Marcuse-Kubitza
08:41 AM Revision 12311: schemas/util.sql: added raise_error_notice()
Aaron Marcuse-Kubitza

02/19/2014

11:59 PM Revision 12310: web/links/index.htm: updated to Firefox bookmarks: Unix: moved into OS folder. Windows: added steps to try for fixing Windows Update.
Aaron Marcuse-Kubitza

02/18/2014

07:16 AM Revision 12309: schemas/vegbien.sql: added remake_diff_tables()
Aaron Marcuse-Kubitza
05:37 AM Revision 12308: bugfix: schemas/util.sql: diff(text, text): also need to include only different rows when comparing single-row tables
Aaron Marcuse-Kubitza

02/17/2014

09:06 PM Revision 12307: schemas/vegbien.sql: added validation_views()
Aaron Marcuse-Kubitza
08:59 PM Revision 12306: schemas/util.sql: show_views_like(): added predictable ordering
Aaron Marcuse-Kubitza
08:54 PM Revision 12305: schemas/util.sql: added show_views_like()
Aaron Marcuse-Kubitza
08:27 PM Revision 12304: schemas/util.sql: added schema_oid()
Aaron Marcuse-Kubitza
06:45 PM Revision 12303: 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.)
Aaron Marcuse-Kubitza
06:38 PM Revision 12302: schemas/util.sql: added set_comment()
Aaron Marcuse-Kubitza
06:25 PM Revision 12301: schemas/util.sql: added eval2records()
Aaron Marcuse-Kubitza
05:48 PM Revision 12300: fix: schemas/util.sql: diff(regclass, regclass): display single row tables side-by-side
Aaron Marcuse-Kubitza
05:46 PM Revision 12299: schemas/util.sql: diff(text, text): implemented the single_row feature
Aaron Marcuse-Kubitza
05:40 PM Revision 12298: 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).
Aaron Marcuse-Kubitza
04:54 PM Revision 12297: fix: schemas/util.sql: remake_diff_table(): util.diff() call: include explicit types on arguments to ensure that the correct diff() variant is used
Aaron Marcuse-Kubitza
04:32 PM Revision 12296: schemas/util.sql: added has_single_row()
Aaron Marcuse-Kubitza
04:08 PM Revision 12295: schemas/vegbien.sql: remake_diff_table(): prepend ~ to the type table so that it sorts at the end, away from the main tables
Aaron Marcuse-Kubitza
03:56 PM Revision 12294: 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().
Aaron Marcuse-Kubitza
03:55 PM Revision 12293: schemas/util.sql: added remake_diff_table()
Aaron Marcuse-Kubitza
03:51 PM Revision 12292: schemas/util.sql: drop_*(): added force param to use CASCADE mode
Aaron Marcuse-Kubitza
03:28 PM Revision 12291: fix: schemas/util.sql: diff(regclass, regclass): usage: col_type_null must actually be a shared base type of the tables
Aaron Marcuse-Kubitza
03:26 PM Revision 12290: fix: schemas/util.sql: diff(regclass, regclass): usage: text arguments must be cast to regclass to bind the right variant of diff()
Aaron Marcuse-Kubitza
03:24 PM Revision 12289: fix: schemas/util.sql: diff(regclass, regclass): renamed params to *_table because these actually can't be views, since views don't support inheritance
Aaron Marcuse-Kubitza
03:03 PM Revision 12288: schemas/util.sql: added copy_struct()
Aaron Marcuse-Kubitza
02:06 PM Revision 12287: schemas/vegbien.sql: added remake_diff_table()
Aaron Marcuse-Kubitza
01:58 PM Revision 12286: bugfix: inputs/bien2_traits/validations.sql: _traits_01_count_records: changed column names to match public_validations._traits_01_count_records
Aaron Marcuse-Kubitza
01:54 PM Revision 12285: schemas/util.sql: added inherit()
Aaron Marcuse-Kubitza
01:46 PM Revision 12284: 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
Aaron Marcuse-Kubitza
01:32 PM Revision 12283: schemas/util.sql: renamed diff_views(), diff_any() to diff(...) because they are overloads of the same operation
Aaron Marcuse-Kubitza
01:22 PM Revision 12282: schemas/util.sql: diff_any(): documented how to run EXPLAIN on the FULL JOIN query
Aaron Marcuse-Kubitza
01:19 PM Revision 12281: schemas/util.sql: removed non-useful diff_queries() (it is not possible to match distinct `record` types to a common return type, so this would not have worked). use diff_views() instead.
Aaron Marcuse-Kubitza
01:14 PM Revision 12280: bugfix: schemas/util.sql: diff_queries(), diff_views(): embed views verbatim as FROM items, so that the type of their corresponding columns is the view's rowtype. this is necessary in order to match the types of the columns to the return type (set by col_type_null).
Aaron Marcuse-Kubitza
12:52 PM Revision 12279: schemas/util.sql: diff_cols(): renamed to diff_queries() because multiple columns are supported
Aaron Marcuse-Kubitza
12:26 PM Revision 12278: fix: schemas/util.sql: diff_cols(): don't assume that each side will have one column, as many of our validations queries have multiple columns
Aaron Marcuse-Kubitza
11:45 AM Revision 12277: bugfix: schemas/util.sql: diff_views(): need to use $2, not $1, for the 2nd query
Aaron Marcuse-Kubitza
11:40 AM Revision 12276: fix: schemas/util.sql: materialize_query(): remove any extra blank line before the query, to improve readability when newlines are used as a log message separator and are therefore confusing in the middle of a log message
Aaron Marcuse-Kubitza
11:37 AM Revision 12275: schemas/util.sql: added ltrim_nl()
Aaron Marcuse-Kubitza
11:25 AM Revision 12274: 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)
Aaron Marcuse-Kubitza
11:14 AM Revision 12273: 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)
Aaron Marcuse-Kubitza
11:05 AM Revision 12272: schemas/util.sql: added mk_set_search_path(VARIADIC schemas text[])
Aaron Marcuse-Kubitza
10:54 AM Revision 12271: schemas/util.sql: added mk_use_own_schema()
Aaron Marcuse-Kubitza
10:52 AM Revision 12270: schemas/util.sql: added mk_set_search_path()
Aaron Marcuse-Kubitza
10:17 AM Revision 12269: schemas/util.sql: use builtin string_agg(..., ) instead of concat()
Aaron Marcuse-Kubitza
12:34 AM Revision 12268: schemas/util.sql: added qual_name(type unknown) to avoid needing to explicitly specify the type of an input string
Aaron Marcuse-Kubitza
12:31 AM Revision 12267: 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)
Aaron Marcuse-Kubitza
12:25 AM Revision 12266: schemas/util.sql: type_qual_name(type regtype): renamed to qual_name(type regtype) to match qual_name(table_ regclass)
Aaron Marcuse-Kubitza
12:17 AM Revision 12265: schemas/util.sql: added rematerialize_query()
Aaron Marcuse-Kubitza

02/16/2014

11:59 PM Revision 12264: schemas/vegbien.sql: added rematerialize_in_view()
Aaron Marcuse-Kubitza
11:16 PM Revision 12263: schemas/vegbien.sql: rematerialize_out_view(): pass a schema-qualified name to util.rematerialize_view() to avoid depending on the search_path to create it in the right schema
Aaron Marcuse-Kubitza
11:08 PM Revision 12262: schemas/vegbien.sql: materialize_query(): support schema-qualified tables. this requires escaping tables in calls to this function.
Aaron Marcuse-Kubitza
10:52 PM Revision 12261: schemas/vegbien.sql: added rematerialize_out_view(in_view regclass)
Aaron Marcuse-Kubitza
10:45 PM Revision 12260: schemas/util.sql: added qual_name()
Aaron Marcuse-Kubitza
09:47 PM Revision 12259: schemas/vegbien.sql: added rematerialize_out_view(datasource_schema text, out_view regclass)
Aaron Marcuse-Kubitza
09:39 PM Revision 12258: bugfix: schemas/vegbien.sql: source_by_shortname(): added schema_anchor so that it always applies to the schema it's defined in, even if `public` is not in the search_path
Aaron Marcuse-Kubitza
09:20 PM Revision 12257: schemas/vegbien.sql: functions with schema_anchors: documented that they must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime changes of search_path (schema elements are bound at inline time rather than runtime)
Aaron Marcuse-Kubitza
09:14 PM Revision 12256: bugfix: schemas/vegbien.sql: functions with schema_anchors: must use plpgsql for these because the sql language does not support runtime changes of search_path (the schema elements they use are bound at inline time rather than runtime)
Aaron Marcuse-Kubitza
08:55 PM Revision 12255: schemas/vegbien.sql: schema_null param: renamed to schema_anchor to clarify what this is for
Aaron Marcuse-Kubitza
08:52 PM Revision 12254: fix: schemas/vegbien.sql: schema_null: clarified that this should *always* be left as the default value, not just usually
Aaron Marcuse-Kubitza
08:49 PM Revision 12253: schemas/vegbien.sql: schema_null params: use schema_anchor instead of source for this, since it is guaranteed to exist regardless of which tables are in the VegBIEN schema
Aaron Marcuse-Kubitza
08:46 PM Revision 12252: schemas/vegbien.sql: public: added schema_anchor (used with schema_null params)
Aaron Marcuse-Kubitza
07:54 PM Revision 12251: schemas/util.sql: use new util.debug_print_sql() instead of `RAISE NOTICE` to improve readability of the debug output (which is used throughout the runscripts)
Aaron Marcuse-Kubitza
07:41 PM Revision 12250: schemas/util.sql: added debug_print_sql()
Aaron Marcuse-Kubitza
07:31 PM Revision 12249: schemas/util.sql: added raise_notice(), to allow NOTICEs to be raised in sql-language functions
Aaron Marcuse-Kubitza
05:56 PM Revision 12248: schemas/vegbien.sql: removed no longer used concat() aggregate. use builtin string_agg() instead.
Aaron Marcuse-Kubitza
05:55 PM Revision 12247: schemas/util.sql: added rematerialize_view()
Aaron Marcuse-Kubitza
04:22 PM Revision 12246: bugfix: inputs/bien2_traits/validations.sql: use a wrapper function for util.ifnull() so that the views don't get dropped when the util schema is reinstalled
Aaron Marcuse-Kubitza
03:24 PM Revision 12245: schemas/util.sql: schema(regtype), schema(regclass): use new schema(pg_namespace_oid oid)
Aaron Marcuse-Kubitza
03:22 PM Revision 12244: schemas/util.sql: added schema(pg_namespace_oid oid)
Aaron Marcuse-Kubitza
03:15 PM Revision 12243: schemas/util.sql: schema(regclass): use joins instead of nested SELECTs for consistency with schema(regtype)
Aaron Marcuse-Kubitza
03:08 PM Revision 12242: schemas/util.sql: regenerated from DB, which reorders the functions
Aaron Marcuse-Kubitza
02:44 PM Revision 12241: schemas/util.sql: table_name(): renamed to name(regclass) for consistency with other name(...) functions
Aaron Marcuse-Kubitza
02:28 PM Revision 12240: schemas/util.sql: table_schema(): renamed to schema(regclass) for consistency with other schema(...) functions
Aaron Marcuse-Kubitza
01:29 PM Revision 12239: web/links/index.htm: updated to Firefox bookmarks: Redmine: added links to the REST API for exporting data. svn: added instructions for using svnsync to export a repository. PostgreSQL: removed duplicate pages that were linked for multiple versions of Postgres.
Aaron Marcuse-Kubitza
06:45 AM Revision 12238: schemas/util.sql: schema_ident(): renamed to schema_esc() for clarity
Aaron Marcuse-Kubitza
06:42 AM Revision 12237: schemas/vegbien.sql: added schema_anchor, for use with schema_null params
Aaron Marcuse-Kubitza
06:39 AM Revision 12236: schemas/util.sql: added mk_search_path()
Aaron Marcuse-Kubitza
02:14 AM Revision 12235: schemas/*.sql: make sure every COMMENT starts and ends on its own line, so that it appears correctly in the formats it's most likely to be read in (ie. in the DDL export, not the COMMENT edit box in pgAdmin)
Aaron Marcuse-Kubitza

02/15/2014

03:51 PM Revision 12234: schemas/util.sql: added materialize_view()
Aaron Marcuse-Kubitza
03:46 PM Revision 12233: schemas/util.sql: added table_name()
Aaron Marcuse-Kubitza
03:45 PM Revision 12232: schemas/util.sql: table_schema(): removed unneeded STRICT, which prevents inlining
Aaron Marcuse-Kubitza
03:41 PM Revision 12231: fix: schemas/util.sql: fix_array(): removed no longer accurate comment about effects of STRICT, which is no longer used
Aaron Marcuse-Kubitza
03:28 PM Revision 12230: fix: schemas/util.sql: materialize_query(): 1st param should be named table_, not view_
Aaron Marcuse-Kubitza
02:50 PM Revision 12229: schemas/util.sql: added drop_view()
Aaron Marcuse-Kubitza
02:46 PM Revision 12228: schemas/util.sql: added materialize_query()
Aaron Marcuse-Kubitza
04:08 AM Revision 12227: /README.TXT: Schema changes: clarified that the staging tables should only be reinstalled if needed
Aaron Marcuse-Kubitza
04:08 AM Revision 12226: /README.TXT: put **...** around all uppercased text, for consistency
Aaron Marcuse-Kubitza

02/14/2014

04:36 PM Revision 12225: _license/non-open-source/applies_to.txt: clarified that this is an exclusions list, not an inclusions list, in terms of what's open-source
Aaron Marcuse-Kubitza
03:09 PM Revision 12224: validation/aggregating/*/*.sql, schemas/vegbien.sql, lib/runscripts/validations.pg.sql.run, inputs/bien2_traits/validations.sql: added _ to beginning of each view name so the validation views would sort at the top in the datasource's tables list. this will also make the validation result sets easily distinguishable from the data tables.
Aaron Marcuse-Kubitza
02:34 PM Revision 12223: validation/aggregating/*/*.sql: renamed views to match the current naming scheme in the DB. these files still need to be kept up-to-date because there are some queries that haven't been implemented yet, and therefore exist only in these files, not the DB.
Aaron Marcuse-Kubitza
12:39 PM Revision 12222: schemas/util.sql: ifnull(): use COALESCE() instead, because it turns out that MySQL's IFNULL() is just a special case of this
Aaron Marcuse-Kubitza
12:20 PM Revision 12221: added inputs/bien2_traits/validations.sql, from validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql
Aaron Marcuse-Kubitza
12:20 PM Revision 12220: inputs/input.Makefile: $(svnFilesGlob): added validations.sql
Aaron Marcuse-Kubitza
12:03 PM Revision 12219: bugfix: validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql: added util to search_path so that IFNULL() would link to util.ifnull()
Aaron Marcuse-Kubitza
11:55 AM Revision 12218: schemas/util.sql: added ifnull(), equivalent to MySQL's IFNULL() (Postgres auto-lowercases the name)
Aaron Marcuse-Kubitza
11:40 AM Revision 12217: lib/sh/util.sh: stderr_matches(): documented that the purpose of not redirecting fd 2 back to fd 2 is to allow log-filtering out an otherwise-confusing benign error
Aaron Marcuse-Kubitza
11:30 AM Revision 12216: lib/sh/util.sh: ignore_err_msg(): documented that unlike `|| true`, this suppresses only errors caused by a particular error *message*, rather than all error exit statuses
Aaron Marcuse-Kubitza
11:28 AM Revision 12215: bugfix: lib/runscripts/validations.pg.sql.run: updated table match pattern to include the type prefix that validations queries now contain
Aaron Marcuse-Kubitza
11:16 AM Revision 12214: bugfix: lib/runscripts/validations.pg.sql.run: --table: need to include explicit schema so that matching tables from other schemas are not included
Aaron Marcuse-Kubitza
11:00 AM Revision 12213: added inputs/bien2_traits/validations.sql.run
Aaron Marcuse-Kubitza
11:00 AM Revision 12212: added lib/runscripts/validations.pg.sql.run
Aaron Marcuse-Kubitza
10:59 AM Revision 12211: lib/sh/util.sh: stdout_contains(): usage: documented that this requires a `{ ... } 41>&1` wrapper
Aaron Marcuse-Kubitza
10:57 AM Revision 12210: lib/sh/util.sh: stderr2stdout(): clarified that fd 2 is *not* redirected back to fd 2
Aaron Marcuse-Kubitza
10:55 AM Revision 12209: bugfix: lib/sh/util.sh: stderr_matches(): need to avoid redirecting stderr and stdout to the same place, because this prevents redirecting stdout back to the original stdout after stderr has been filtered using |
Aaron Marcuse-Kubitza
10:23 AM Revision 12208: lib/sh/util.sh: local_export_array: renamed to just export_array because this was a replacement for export, not local_export
Aaron Marcuse-Kubitza
10:21 AM Revision 12207: lib/sh/util.sh: local_*array: don't need -a because that it's an array is autodetected by the ()
Aaron Marcuse-Kubitza
10:20 AM Revision 12206: lib/sh/util.sh: stderr_matches(): actually don't need to declare PIPESTATUS_ in a separate command, because local does support arrays
Aaron Marcuse-Kubitza
10:18 AM Revision 12205: lib/sh/util.sh: added local_export_array
Aaron Marcuse-Kubitza
10:17 AM Revision 12204: fix: lib/sh/util.sh: local_array: clarified that this is only needed for older versions of bash (the lack of support for arrays has apparently been fixed)
Aaron Marcuse-Kubitza
10:12 AM Revision 12203: lib/sh/util.sh: added local_array
Aaron Marcuse-Kubitza
10:07 AM Revision 12202: fix: lib/sh/util.sh: stderr_matches(): usage: documented that now need to manually rethrow any command error, if applicable
Aaron Marcuse-Kubitza
10:04 AM Revision 12201: *{.sh,run}: stderr_matches calls: don't need to wrap the command in `"try"` because stderr_matches now does this
Aaron Marcuse-Kubitza
09:55 AM Revision 12200: fix: lib/sh/util.sh: `shopt -s lastpipe`: suppress error message if not supported
Aaron Marcuse-Kubitza
09:50 AM Revision 12199: lib/sh/util.sh: ignore_err_msg(): use new stderr_matches alias, which includes prep_try (requires loading new aliases)
Aaron Marcuse-Kubitza
09:49 AM Revision 12198: bugfix: lib/sh/util.sh: stderr_matches(): need to save PIPESTATUS and then use the saved var because it's reset after each cmd
Aaron Marcuse-Kubitza
09:39 AM Revision 12197: lib/sh/util.sh: stderr_matches(): place exit status of cmd in $e for use with exception handling
Aaron Marcuse-Kubitza
09:21 AM Revision 12196: lib/sh/util.sh: set `shopt -s lastpipe`, to allow setting vars in the last command of a pipeline
Aaron Marcuse-Kubitza
08:43 AM Revision 12195: bugfix: lib/sh/util.sh: ignore_err_msg(): use `try` properly with prep_try and `"try"`
Aaron Marcuse-Kubitza
08:39 AM Revision 12194: lib/sh/util.sh: added prep_try and use it in try alias. try: documented how to run it with a wrapper command.
Aaron Marcuse-Kubitza
08:21 AM Revision 12193: lib/sh/db.sh: pg_dump(): ignore "No matching tables were found" error, using new ignore_err_msg()
Aaron Marcuse-Kubitza
08:20 AM Revision 12192: lib/sh/util.sh: added ignore_err_msg()
Aaron Marcuse-Kubitza
07:34 AM Revision 12191: lib/sh/db.sh: pg_schema_exists(): documented that `try` is used to suppress the error exit status
Aaron Marcuse-Kubitza
07:31 AM Revision 12190: lib/sh/util.sh: stderr_matches(): usage: surrounded command in if statement to indicate what context it would usually be used in
Aaron Marcuse-Kubitza

02/13/2014

05:01 PM Revision 12189: lib/runscripts/file.pg.sql.run, schema.pg.sql.run: support custom options to pg_dump in $@
Aaron Marcuse-Kubitza
04:10 PM Revision 12188: validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql: added view names using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW
Aaron Marcuse-Kubitza
04:10 PM Revision 12187: validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql: removed trailing whitespace
Aaron Marcuse-Kubitza
04:06 PM Revision 12186: schemas/vegbien.sql: public_validations_*: merged into single public_validations schema, with type-specific prefixes for each query, so that datasources can use validations queries from multiple type categories, and so that each datasource doesn't have to indicate which validations output schema it's using
Aaron Marcuse-Kubitza
02:23 PM Revision 12185: schemas/util.sql: diff_cols(): documented how to run EXPLAIN on the FULL JOIN query
Aaron Marcuse-Kubitza
02:14 PM Revision 12184: schemas/util.sql: diff_cols(): embed left_query/right_query directly in the main SQL statement, so that the query planner can take the sort order of the queries into account in planning the FULL JOIN (and where possible, use a fast merge join)
Aaron Marcuse-Kubitza
02:09 PM Revision 12183: schemas/vegbien.sql: regenerated from DB, which adds an autogenerated column alias
Aaron Marcuse-Kubitza
02:06 PM Revision 12182: schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*
Aaron Marcuse-Kubitza
02:05 PM Revision 12181: schemas/util.sql: added eval2col_pair()
Aaron Marcuse-Kubitza
01:23 PM Revision 12180: web/.phpPgAdmin/.htaccess: support linking to a function
Aaron Marcuse-Kubitza
01:08 PM Revision 12179: web/.phpPgAdmin/.htaccess: support linking to the functions list
Aaron Marcuse-Kubitza
01:05 PM Revision 12178: web/.phpPgAdmin/.htaccess: support linking to a view
Aaron Marcuse-Kubitza
12:58 PM Revision 12177: web/.phpPgAdmin/.htaccess: allow linking directly to the views list of a schema
Aaron Marcuse-Kubitza
12:54 PM Revision 12176: added backups/vegbien.r12025.backup.md5
Aaron Marcuse-Kubitza
12:54 PM Revision 12175: web/.phpPgAdmin/.htaccess: refactored to build the URL incrementally, extracting path components 1st->last, instead of handling each # of path components as a separate case (which was more rigid and created unnecessary duplication)
Aaron Marcuse-Kubitza
12:53 PM Revision 12174: backups/TNRS.backup.md5: updated
Aaron Marcuse-Kubitza
11:47 AM Revision 12173: bugfix: web/.phpPgAdmin/.htaccess: path RewriteRules: need to go directly to the applicable tab, rather than going via redirect.php, because redirect.php will use the *last selected tab*, rather than the first tab for that section, leading to unexpected results when a non-default tab was previously selected
Aaron Marcuse-Kubitza
10:41 AM Revision 12172: schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*
Aaron Marcuse-Kubitza
10:33 AM Revision 12171: validation/aggregating/pipeline/aggregating_validations_pipeline.odg: made "diff tables" the same size as the other major labels
Aaron Marcuse-Kubitza
10:30 AM Revision 12170: validation/aggregating/pipeline/aggregating_validations_pipeline.odg: added CSVs export arrows and import process arrows, as decided in conference call
Aaron Marcuse-Kubitza
08:34 AM Revision 12169: schemas/vegbien.sql: public_validation_plots: added Brad's notes as comments
Aaron Marcuse-Kubitza
08:29 AM Revision 12168: schemas/vegbien.sql: public_validation_plots: populated queries from validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
Aaron Marcuse-Kubitza
08:26 AM Revision 12167: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _12_count_of_verbatim_taxa_per_plot_in_each_project: removed typo (in the original queries, not added by the refactoring)
Aaron Marcuse-Kubitza
08:23 AM Revision 12166: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: shortened view names to fit in the 63-char limit
Aaron Marcuse-Kubitza
08:20 AM Revision 12165: schemas/vegbien.sql: public_validation_traits: added Brad's notes as comments
Aaron Marcuse-Kubitza
08:17 AM Revision 12164: schemas/vegbien.sql: public_validation_traits: populated queries from validation/aggregating/traits/bien3_validations_traits_bien3.sql
Aaron Marcuse-Kubitza
08:02 AM Revision 12163: validation/aggregating/*/*.sql: use "" to preserve case in column aliases, so that they match the input queries
Aaron Marcuse-Kubitza
07:58 AM Revision 12162: validation/aggregating/*/*.sql: use current_schema instead of a hardcoded datasource name or psql variable
Aaron Marcuse-Kubitza
07:49 AM Revision 12161: validation/aggregating/*/*.sql: search_path: added public
Aaron Marcuse-Kubitza
07:45 AM Revision 12160: validation/aggregating/*/*.sql: use the new type-specific validation schema names
Aaron Marcuse-Kubitza
07:41 AM Revision 12159: validation/aggregating/*/*.sql: removed type-specific prefix from the view name, which is now part of the validation schema
Aaron Marcuse-Kubitza
07:26 AM Revision 12158: inputs/import.stats.xls: updated import times
Aaron Marcuse-Kubitza
06:53 AM Revision 12157: inputs/import.stats.xls: updated import times
Aaron Marcuse-Kubitza
05:58 AM Revision 12156: schemas/vegbien.sql: analytical_stem.datasource: removed fkey to source.shortname because this prevents individually-reloaded datasources from being published
Aaron Marcuse-Kubitza
05:56 AM Revision 12155: schemas/vegbien.sql: publish(), rm(): documented runtime (1 min)
Aaron Marcuse-Kubitza
05:49 AM Revision 12154: schemas/vegbien.sql: added datasource_unpublish()
Aaron Marcuse-Kubitza
03:48 AM Revision 12153: lib/sql_io.py: automatic handling of input/output column type mismatches: also do this for identifying columns, which first cause an error in a join in sql.distinct_table() rather than in the main insert (and thus were not handled by the existing error handling). previously, the user would have had to manually cast the input column in postprocess.sql. this involves getting handle_MissingCastException() to update join_cols as well as mapping.
Aaron Marcuse-Kubitza
03:37 AM Revision 12152: lib/sql.py: distinct_table(): don't cache the table creation, because this prevents different distinct_tables from being created for the same input table
Aaron Marcuse-Kubitza
03:36 AM Revision 12151: lib/sql.py: create_table(), copy_table_struct(): support custom query options, such as cacheable
Aaron Marcuse-Kubitza
12:29 AM Revision 12150: lib/sql_io.py: put_table(): main loop MissingCastException handler: factored out into nested function so that it can also be used elsewhere
Aaron Marcuse-Kubitza
12:01 AM Revision 12149: lib/sql.py: parse_exception(): parse "operator does not exist" errors as MissingCastExceptions (these appear when a staging table column is of the wrong type)
Aaron Marcuse-Kubitza

02/08/2014

11:17 PM Revision 12148: bugfix: /README.TXT: Full database import: Check that source contains [# datasources] rows up through XAL: added alternative verification method when this is not the case (some datasources may be near the end depending on import order)
Aaron Marcuse-Kubitza
10:38 PM Revision 12147: schemas/vegbien.sql: public_validation: split into separate subschemas for plots, specimens, traits
Aaron Marcuse-Kubitza
10:33 PM Revision 12146: schemas/Makefile: vegbien.sql: support auxiliary schemas besides *_validation
Aaron Marcuse-Kubitza
10:03 PM Revision 12145: fix: schemas/Makefile: %/publish: removed no longer applicable instructions about running `make schemas/rotate`. you should not publish a schema until you are satisfied that it can replace the previous public schema, so that the previous public schema doesn't need to be saved.
Aaron Marcuse-Kubitza
10:00 PM Revision 12144: fix: schemas/vegbien.sql: public_validation comment: undid incorrect replacement of "validation" with "public_validation"
Aaron Marcuse-Kubitza
09:59 PM Revision 12143: bugfix: schemas/Makefile: "public": dont
Aaron Marcuse-Kubitza
09:37 PM Revision 12142: schemas/Makefile: %/publish: don't ignore errors if schema doesn't exist, because it should always exist if you are publishing it
Aaron Marcuse-Kubitza
09:36 PM Revision 12141: schemas/Makefile: `%/uninstall: vegbien.sql`: use util.schema_bundle_rm() instead of public.rm(), because when the public schema is incompletely imported, public.rm() will not yet exist
Aaron Marcuse-Kubitza
09:34 PM Revision 12140: schemas/Makefile: `%/install: vegbien.sql`: support auxiliary schemas besides *_validation
Aaron Marcuse-Kubitza
09:16 PM Revision 12139: schemas/Makefile: %/uninstall, %/publish: use new public.rm(), publish(), which encapsulate the process of renaming multiple related schemas and also allow additional auxiliary schemas beyond just *_validation
Aaron Marcuse-Kubitza
03:55 PM Revision 12138: schemas/vegbien.sql: added rm(), which deletes this schema
Aaron Marcuse-Kubitza
03:17 PM Revision 12137: schemas/vegbien.sql: added publish(), which publishes this schema
Aaron Marcuse-Kubitza
02:47 PM Revision 12136: schemas/vegbien.sql: added public_schema_publish()
Aaron Marcuse-Kubitza
02:21 PM Revision 12135: schemas/util.sql: added functions for maintaining schema bundles, groups of schemas with a common prefix
Aaron Marcuse-Kubitza
04:26 AM Revision 12134: schemas/util.sql: added schema_bundle_get_schemas()
Aaron Marcuse-Kubitza

02/07/2014

11:36 PM Revision 12133: schemas/util.sql: added schema_replace()
Aaron Marcuse-Kubitza
11:11 PM Revision 12132: schemas/util.sql: added schema_rm(), schema_rename()
Aaron Marcuse-Kubitza
08:30 PM Revision 12131: schemas/vegbien.sql: datasource_publish(): removed nested transaction, which is not needed because Postgres runs each top-level command in a transaction (including in autocommit mode)
Aaron Marcuse-Kubitza
06:58 PM Revision 12130: bugfix: schemas/Makefile,vegbien.sql: renamed validation to public_validation to match the suffixed name applied by `make schemas/public/install`
Aaron Marcuse-Kubitza
05:58 PM Revision 12129: schemas/Makefile: %/install, %/publish for public schema: added usage
Aaron Marcuse-Kubitza
08:37 AM Revision 12128: /README.TXT: to back up the version history: added back `git svn fetch` so we keep the git export up-to-date, too
Aaron Marcuse-Kubitza
08:29 AM Revision 12127: /README.TXT: to back up the version history: added runtimes (1.5 h for the initial svnsync)
Aaron Marcuse-Kubitza
08:24 AM Revision 12126: /README.TXT: to back up the version history: added trailing /s to dirs
Aaron Marcuse-Kubitza
08:24 AM Revision 12125: bugfix: /README.TXT: to back up the version history: fixed svn_repo/ path
Aaron Marcuse-Kubitza
08:16 AM Revision 12124: **/LICENSE.TXT: corrected "it recommended" to "it is recommended"
Aaron Marcuse-Kubitza
08:12 AM Revision 12123: _license/non-open-source/applies_to.txt: deleted items: tip revision needs to refer to the revision *at which* the problem was discovered, not the revision before that
Aaron Marcuse-Kubitza
08:10 AM Revision 12122: _license/non-open-source/applies_to.txt: deleted items: clarified that some things deleted after r11705 (when we started copyright scrubbing) might also be non-open-source, because they might have been deleted for reasons other than copyright scrubbing and thus would be missing the "copyright scrub" tag
Aaron Marcuse-Kubitza
08:09 AM Revision 12121: _license/non-open-source/applies_to.txt: deleted items: clarified that some things deleted after r11705 (when we started copyright scrubbing) might also be non-open-source, because they might have been deleted for reasons other than copyright scrubbing and thus would be missing the "copyright scrub" tag
Aaron Marcuse-Kubitza
08:00 AM Revision 12120: /LICENSE.TXT: removed separate non-open-source disclaimer about parts of the version history before r11705, because this is now listed in _license/non-open-source/applies_to.txt
Aaron Marcuse-Kubitza
07:59 AM Revision 12119: _license/non-open-source/applies_to.txt: included deleted items that are non-open-source, so that the list correctly applies to the entire repository (which includes the version history)
Aaron Marcuse-Kubitza
07:51 AM Revision 12118: **/LICENSE.TXT: disclaimer about things that are not open-source: removed "these are copyright their respective owners", because this is understood
Aaron Marcuse-Kubitza
07:22 AM Revision 12117: _license/README.TXT: changed "parts" to "components" for clarity
Aaron Marcuse-Kubitza
07:18 AM Revision 12116: _license/non-open-source/applies_to.txt: UArizona?: added BIEN2/traits_observation_counts.xls
Aaron Marcuse-Kubitza
06:52 AM Revision 12115: /README.TXT: to back up the version history: use svnsync instead of `git svn fetch`, so that the backup is in a format that can be directly reimported into an svn repo
Aaron Marcuse-Kubitza
05:53 AM Revision 12114: /LICENSE.TXT: parts of the repository that are not open-source: added ,s to clarify the meaning
Aaron Marcuse-Kubitza
05:39 AM Revision 12113: /LICENSE.TXT: documented that this license refers specifically to the repository hosted at https://code.nceas.ucsb.edu/code/projects/bien/trunk/, since we also have a publicly-accessible checkout at http://fs.vegpath.org/, which contains numerous non-open-source files (more than are listed in _license/non-open-source/applies_to.txt)
Aaron Marcuse-Kubitza
05:37 AM Revision 12112: fix: inputs/VegBIEN/Redmine/wiki/.htaccess: redirect to new main page when accessed without trailing /
Aaron Marcuse-Kubitza
05:26 AM Revision 12111: web/BIEN3: redirected to .wiki since the wiki homepage now contains the list of all BIEN3 components
Aaron Marcuse-Kubitza
05:26 AM Revision 12110: web/links/index.htm: updated to Firefox bookmarks. Quick links: use bien3.vegpath.org to link to the main BIEN3 page
Aaron Marcuse-Kubitza
05:05 AM Revision 12109: added web/BIEN3 symlink, with .bien3 case-insensitive alias
Aaron Marcuse-Kubitza
04:44 AM Revision 12108: _license/*/applies_to.txt: added exclusion for "UCSB modifications"
Aaron Marcuse-Kubitza
04:38 AM Revision 12107: added _license/GPL2.txt.url
Aaron Marcuse-Kubitza
04:36 AM Revision 12106: /LICENSE.TXT, _license/VegBank_schema/LICENSE.TXT: moved text of the GPL2 license into separate file _license/GPL2.txt to avoid cluttering up LICENSE.TXT
Aaron Marcuse-Kubitza
04:36 AM Revision 12105: _license/*/LICENSE.TXT: documented that the first section of the file is from license.eml.txt in each folder
Aaron Marcuse-Kubitza
04:33 AM Revision 12104: /LICENSE.TXT, _license/VegBank_schema/LICENSE.TXT: moved text of the GPL2 license into separate file _license/GPL2.txt to avoid cluttering up LICENSE.TXT
Aaron Marcuse-Kubitza
04:23 AM Revision 12103: /LICENSE.TXT: GPL text: include the full range of copyright years
Aaron Marcuse-Kubitza
04:17 AM Revision 12102: /LICENSE.TXT: added disclaimer that parts of the version history before r11705 (2013-11-21) are *NOT* open-source. this is the revision of the first copyright scrub.
Aaron Marcuse-Kubitza
04:02 AM Revision 12101: added issues/ with LICENSE.TXT for the issue tracker (BSD)
Aaron Marcuse-Kubitza
03:51 AM Revision 12100: wiki/_license/*/: symlink the contents instead of the folders, because the root dir's and wiki's applies_to.txt's will be different
Aaron Marcuse-Kubitza
03:49 AM Revision 12099: wiki/_license/*/: symlink the contents instead of the folders, because the root dir's and wiki's applies_to.txt's will be different
Aaron Marcuse-Kubitza
03:45 AM Revision 12098: wiki/LICENSE.TXT: documented what this license refers to (the wiki hosted at https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/)
Aaron Marcuse-Kubitza
03:43 AM Revision 12097: wiki/LICENSE.TXT: added message about including _license/ when redistributing, as for /LICENSE.TXT
Aaron Marcuse-Kubitza
03:42 AM Revision 12096: wiki/_license/LICENSE.TXT: replaced with README.TXT as in /_license
Aaron Marcuse-Kubitza
03:41 AM Revision 12095: wiki/LICENSE.TXT: changed "the page text of the wiki" to "the wiki's components" since some of the attachments will eventually be marked as open-source
Aaron Marcuse-Kubitza
03:39 AM Revision 12094: /LICENSE.TXT: moved emphasized sections to top
Aaron Marcuse-Kubitza
03:37 AM Revision 12093: /LICENSE.TXT: changed "the open-source parts of the repository" to "the repository's components" so that this sentence makes sense once the non-open-source exception is removed
Aaron Marcuse-Kubitza
03:36 AM Revision 12092: /LICENSE.TXT: documented that the non-open-source files are now listed in _license/non-open-source/applies_to.txt
Aaron Marcuse-Kubitza
03:33 AM Revision 12091: added _license/non-open-source/applies_to.txt
Aaron Marcuse-Kubitza
03:24 AM Revision 12090: removed schemas/VegX/run.py, which is a duplicate of _archive/bienDjango/trunk/bien/v/models.py (this may have ended up here because it was a wiki page attachment, but the initial revision did not indicate the source)
Aaron Marcuse-Kubitza
03:09 AM Revision 12089: added _license/VegBank_schema/applies_to.txt
Aaron Marcuse-Kubitza
03:02 AM Revision 12088: schemas/VegCore/vegbien_identifier_examples.xlsx: changed to symlink to Brad_Boyle/vegbien_identifier_examples.xlsx, to avoid duplicate copies
Aaron Marcuse-Kubitza
02:52 AM Revision 12087: added _license/TWiki/ (for inputs/VegBIEN/TWiki/)
Aaron Marcuse-Kubitza
02:38 AM Revision 12086: added _license/PostgreSQL_config (for schemas/*.conf)
Aaron Marcuse-Kubitza
02:24 AM Revision 12085: */LICENSE.TXT: GPL: removed divider between the copyright header and license text, since these are part of the same license
Aaron Marcuse-Kubitza
02:19 AM Revision 12084: _license/ESA/: renamed to VegBank_schema/ because this license applies only to the VegBank schema
Aaron Marcuse-Kubitza
02:18 AM Revision 12083: _license/README.TXT: merged ¶2 into ¶1
Aaron Marcuse-Kubitza
02:04 AM Revision 12082: _license/README.TXT: replaced "authority information proving the open-source status" with the simpler "open-source proof". clarified that each LICENSE.TXT is meant as a proof.
Aaron Marcuse-Kubitza
01:52 AM Revision 12081: /LICENSE.TXT: added note that when redistributing, it recommended to include _license/, so that the open-source proof is included along with the license text (this information should be here as well as in _license/README.TXT because redistributors might not think to look in that file)
Aaron Marcuse-Kubitza
01:49 AM Revision 12080: /LICENSE.TXT: removed "svn" before "repository" because this would apply equally to a git export of the repository
Aaron Marcuse-Kubitza
01:47 AM Revision 12079: /LICENSE.TXT: replaced "portions" with "parts" for consistency with the _license/README.TXT wording
Aaron Marcuse-Kubitza
01:44 AM Revision 12078: _license/README.TXT: clarified that this folder contains authority information proving the open-source status of parts of the codebase. added recommendation to include this folder when redistributing, so that the open-source proof is included along with the license text.
Aaron Marcuse-Kubitza
01:32 AM Revision 12077: _license/LICENSE.TXT: renamed to README.TXT because this actually contains a description of the folder, not license text
Aaron Marcuse-Kubitza
01:24 AM Revision 12076: schemas/Makefile: removed no longer used rename/%, rotate. use %/install, %/publish instead to manage public schema versions.
Aaron Marcuse-Kubitza
01:22 AM Revision 12075: schemas/Makefile: removed no longer needed public/uninstall, which is handled more generally by `%/uninstall: vegbien.sql` instead
Aaron Marcuse-Kubitza
01:21 AM Revision 12074: schemas/Makefile: `%/uninstall: vegbien.sql`: added support for *_validation schema
Aaron Marcuse-Kubitza
01:16 AM Revision 12073: schemas/Makefile: %/uninstall: split into 2 rules like for %/install, so that different actions can easily be added for the public schema
Aaron Marcuse-Kubitza
01:13 AM Revision 12072: schemas/Makefile: %/publish: support auxiliary *_validation schemas
Aaron Marcuse-Kubitza
01:12 AM Revision 12071: bugfix: schemas/Makefile: `%/install: vegbien.sql`: need -e before each s/// expression
Aaron Marcuse-Kubitza

02/06/2014

07:34 PM Revision 12070: schemas/Makefile: `%/install: vegbien.sql`: create a custom *_validation schema for *each* public schema, rather than one for the most recently-created public schema. this allows validations to continue to be run against a previous version of the DB while a new version is being imported.
Aaron Marcuse-Kubitza
04:48 PM Revision 12069: validation/aggregating/traits/bien3_validations_traits_bien3.sql: include only records from the bien2_traits datasource, to ensure that the scope of all queries is limited to the datasource
Aaron Marcuse-Kubitza
04:16 PM Revision 12068: validation/aggregating/*/*.sql (the output queries): added `SET search_path TO validation`
Aaron Marcuse-Kubitza
04:12 PM Revision 12067: validation/aggregating/specimens/qualitative_validations_specimens.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW
Aaron Marcuse-Kubitza
04:11 PM Revision 12066: validation/aggregating/traits/bien3_validations_traits_bien3.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW
Aaron Marcuse-Kubitza
04:03 PM Revision 12065: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW
Aaron Marcuse-Kubitza
03:47 PM Revision 12064: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW
Aaron Marcuse-Kubitza
02:48 PM Revision 12063: added validation/aggregating/specimens/qualitative_validations_specimens.sql template, with query descriptions from NY/qualitative_validations_source_db_NYBG.sql
Aaron Marcuse-Kubitza
02:08 PM Revision 12062: validation/**: removed old versions of by=-tagged files. these were not renamed in the last commit because there were newer versions that they collided with. note that because , sorts before . , the newer version (with more ",name@inst" tags) was correctly renamed instead of the older version.
Aaron Marcuse-Kubitza
01:56 PM Revision 12061: validation/**: removed by=... indicators so that we don't have to add an author name every time a file is changed. the author indicator is not needed now that both Brad's and my edits are open-source.
Aaron Marcuse-Kubitza
01:14 PM Revision 12060: inputs/bien2_traits/TraitObservation/postprocess.sql: remove rows with no taxon name, which are invalid, and which helps simplify the aggregating validations queries
Aaron Marcuse-Kubitza
12:33 PM Revision 12059: added validation/aggregating/pipeline/aggregating_validations_pipeline.odg with .png export
Aaron Marcuse-Kubitza
11:09 AM Revision 12058: added validation/aggregating/plots/FIA/bien3_validations_fia_input.sql.eml.txt. note that a .url file is not needed because this information is in the .eml.txt file.
Aaron Marcuse-Kubitza
10:57 AM Revision 12057: fix: validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=Brad@iPlant.sql: renamed to indicate that this is actually *not* Brad's original file, as the filename would seem to indicate
Aaron Marcuse-Kubitza
10:49 AM Revision 12056: added validation/aggregating/plots/FIA/
Aaron Marcuse-Kubitza
03:46 AM Revision 12055: validation/aggregating/*.by=Brad@iPlant*: placed under version control, since these are now open-source
Aaron Marcuse-Kubitza
03:41 AM Revision 12054: validation/**: removed svn:ignore exclusion of iPlant-owned files, since these are now open-source
Aaron Marcuse-Kubitza
03:05 AM Revision 12053: fix: inputs/VegBIEN/Redmine/svn/.htaccess: updated repository URL to point to trunk/
Aaron Marcuse-Kubitza
03:03 AM Revision 12052: added wiki/LICENSE.TXT,_license/, with license terms that apply specifically to the wiki (which is *BSD*, not GPL). note that the wiki attachments are *NOT* open-source, only the page text.
Aaron Marcuse-Kubitza
02:44 AM Revision 12051: schemas/vegbien.ERD.mwb: regenerated exports
Aaron Marcuse-Kubitza
02:41 AM Revision 12050: _license/VegBank/: renamed to ESA/ following the convention that each _license/ subfolder is a copyright owner
Aaron Marcuse-Kubitza

02/05/2014

06:03 PM Revision 12049: /LICENSE.TXT: added collective license conditions (GPL2+) for the svn repository as a whole, except the non-open-source portions
Aaron Marcuse-Kubitza
05:50 PM Revision 12048: added _license/VegBank/
Aaron Marcuse-Kubitza
05:24 PM Revision 12047: added LICENSE.TXT and related files (in _license/). the open-source portions of the svn repository are licensed as described in _license/. note that some portions of the svn repository are *NOT* open-source. these are copyright their respective owners.
Aaron Marcuse-Kubitza
06:05 AM Revision 12046: schemas/vegbien.ERD.mwb: synced to schemas/vegbien.my.sql, which adds the validation schema
Aaron Marcuse-Kubitza
05:51 AM Revision 12045: schemas/util.sql: added diff_views()
Aaron Marcuse-Kubitza
05:31 AM Revision 12044: schemas/util.sql: added diff_cols(), for use with the aggregating validations
Aaron Marcuse-Kubitza
01:16 AM Revision 12043: bugfix: schemas/Makefile: public/uninstall: need to uninstall the validation schema in addition to the public schema (deleting the public schema would only cascade to the *contents* of the validation schema)
Aaron Marcuse-Kubitza
01:02 AM Revision 12042: schemas/vegbien.sql: added validation schema, which contains queries used in the aggregating validations. schemas/Makefile: include schemas that depend on `public` (eg. `validation`) so they are restored along with it.
Aaron Marcuse-Kubitza
12:55 AM Revision 12041: bugfix: bin/pg_dump_vegbien: fixed arg-count check to allow passing command-line options to pg_dump via args
Aaron Marcuse-Kubitza

02/04/2014

10:42 AM Revision 12040: bugfix: inputs/SALVIAS/verify/plots.out.sql: fixed ' quoting syntax to use '' instead of \' to escape '
Aaron Marcuse-Kubitza
10:32 AM Revision 12039: inputs/input.Makefile: verify/%.out: use a *.sql file in the verify/ directory itself to generate *.out, so that each datasource can have its own set of output queries. for datasources that should share the same set of queries, they can instead be symlinked to the same file.
Aaron Marcuse-Kubitza
10:01 AM Revision 12038: fix: inputs/CVS/project/: added _no_import since this should not also be imported separately from taxon_observation.**
Aaron Marcuse-Kubitza
04:21 AM Revision 12037: fix: validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=Brad@iPlant,Aaron@UCSB,Brad@iPlant.sql: added missing .url extension
Aaron Marcuse-Kubitza
 

Also available in: Atom