Revision 12154
Added by Aaron Marcuse-Kubitza almost 11 years ago
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
schemas/vegbien.sql: added datasource_unpublish()