/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12262

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/vegbien.sql: materialize_query(): support schema-qualified tables. this requires escaping tables in calls to this function.

     -- Name: materialize_query(text, text); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION materialize_query(table_ text, sql text) RETURNS void
     CREATE FUNCTION materialize_query(table_esc text, sql text) RETURNS void
         LANGUAGE sql
         AS $_$
     SELECT util.create_if_not_exists($$CREATE TABLE $$||quote_ident($1)||$$ AS
     SELECT util.create_if_not_exists($$CREATE TABLE $$||$1||$$ AS
     $$||$2)
     $_$;
     --
     -- Name: FUNCTION materialize_query(table_ text, sql text); Type: COMMENT; Schema: util; Owner: -
     -- Name: FUNCTION materialize_query(table_esc text, sql text); Type: COMMENT; Schema: util; Owner: -
     --
     COMMENT ON FUNCTION materialize_query(table_ text, sql text) IS '
     COMMENT ON FUNCTION materialize_query(table_esc text, sql text) IS '
     idempotent
     ';
-...
     -- Name: materialize_view(text, regclass); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION materialize_view(table_ text, view_ regclass) RETURNS void
     CREATE FUNCTION materialize_view(table_esc text, view_ regclass) RETURNS void
         LANGUAGE sql
         AS $_$
     SELECT util.materialize_query($1, $$SELECT * FROM $$||$2)
-...
     --
     -- Name: FUNCTION materialize_view(table_ text, view_ regclass); Type: COMMENT; Schema: util; Owner: -
     -- Name: FUNCTION materialize_view(table_esc text, view_ regclass); Type: COMMENT; Schema: util; Owner: -
     --
     COMMENT ON FUNCTION materialize_view(table_ text, view_ regclass) IS '
     COMMENT ON FUNCTION materialize_view(table_esc text, view_ regclass) IS '
     idempotent
     ';
-...
     -- Name: rematerialize_view(text, regclass); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION rematerialize_view(table_ text, view_ regclass) RETURNS void
     CREATE FUNCTION rematerialize_view(table_esc text, view_ regclass) RETURNS void
         LANGUAGE sql
         AS $_$
     SELECT util.drop_table($1);
-...
     --
     -- Name: FUNCTION rematerialize_view(table_ text, view_ regclass); Type: COMMENT; Schema: util; Owner: -
     -- Name: FUNCTION rematerialize_view(table_esc text, view_ regclass); Type: COMMENT; Schema: util; Owner: -
     --
     COMMENT ON FUNCTION rematerialize_view(table_ text, view_ regclass) IS '
     COMMENT ON FUNCTION rematerialize_view(table_esc text, view_ regclass) IS '
     idempotent, but repeats action each time
     ';

     changes of search_path (schema elements are bound at inline time rather than
     runtime) */
     DECLARE
     	out_table text = '_out_'||util.name(out_view);
     	out_table text = quote_ident('_out_'||util.name(out_view));
     BEGIN
     	/* datasource_schema must be 1st in the search_path so that queries can use
     	it in current_schema, and so that out_table is created in the datasource's

Also available in: Unified diff

Project

General

Profile

Revision 12262

Added by Aaron Marcuse-Kubitza almost 11 years ago