Project

General

Profile

« Previous | Next » 

Revision 12154

schemas/vegbien.sql: added datasource_unpublish()

View differences:

trunk/schemas/vegbien.my.sql
444 444

  
445 445

  
446 446
--
447
-- Name: datasource_unpublish(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: -
448
--
449

  
450

  
451

  
452

  
453
--
454
-- Name: FUNCTION datasource_unpublish(datasource varchar(255), schema_null anyelement); Type: COMMENT; Schema: public; Owner: -
455
--
456

  
457

  
458

  
459

  
460
--
447 461
-- Name: delete_scrubbed_taxondeterminations(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
448 462
--
449 463

  
trunk/schemas/vegbien.sql
818 818

  
819 819

  
820 820
--
821
-- Name: datasource_unpublish(text, anyelement); Type: FUNCTION; Schema: public; Owner: -
822
--
823

  
824
CREATE FUNCTION datasource_unpublish(datasource text, schema_null anyelement DEFAULT NULL::source) RETURNS void
825
    LANGUAGE sql
826
    AS $_$
827
SELECT set_config('search_path', util.schema_ident($3), true);
828
SELECT datasource_rename($1, $1||'.new');
829
$_$;
830

  
831

  
832
--
833
-- Name: FUNCTION datasource_unpublish(datasource text, schema_null anyelement); Type: COMMENT; Schema: public; Owner: -
834
--
835

  
836
COMMENT ON FUNCTION datasource_unpublish(datasource text, schema_null anyelement) IS 'secure against renamings of the public schema.
837

  
838
schema_null: identifies which schema''s tables to use. the default value is usually fine.
839
';
840

  
841

  
842
--
821 843
-- Name: delete_scrubbed_taxondeterminations(text); Type: FUNCTION; Schema: public; Owner: -
822 844
--
823 845

  

Also available in: Unified diff