Project

General

Profile

« Previous | Next » 

Revision 10857

schemas/vegbien.sql: added datasource_publish()

View differences:

vegbien.sql
720 720

  
721 721

  
722 722
--
723
-- Name: datasource_publish(text, anyelement); Type: FUNCTION; Schema: public; Owner: -
724
--
725

  
726
CREATE FUNCTION datasource_publish(datasource text, schema_null anyelement DEFAULT NULL::source) RETURNS void
727
    LANGUAGE sql
728
    AS $_$
729
SELECT set_config('search_path', util.schema_ident($2), true);
730
SELECT datasource_rm($1, $2);
731
SELECT datasource_rename($1, rm_version_suffix($1), $2);
732
$_$;
733

  
734

  
735
--
736
-- Name: FUNCTION datasource_publish(datasource text, schema_null anyelement); Type: COMMENT; Schema: public; Owner: -
737
--
738

  
739
COMMENT ON FUNCTION datasource_publish(datasource text, schema_null anyelement) IS 'secure against renamings of the public schema.
740

  
741
schema_null: identifies which schema''s tables to use. the default value is usually fine.
742
';
743

  
744

  
745
--
723 746
-- Name: datasource_rename(text, text, anyelement); Type: FUNCTION; Schema: public; Owner: -
724 747
--
725 748

  

Also available in: Unified diff