Revision 12138
Added by Aaron Marcuse-Kubitza almost 11 years ago
vegbien.sql | ||
---|---|---|
1313 | 1313 |
|
1314 | 1314 |
|
1315 | 1315 |
-- |
1316 |
-- Name: rm(anyelement); Type: FUNCTION; Schema: public; Owner: - |
|
1317 |
-- |
|
1318 |
|
|
1319 |
CREATE FUNCTION rm(schema_null anyelement DEFAULT NULL::source) RETURNS void |
|
1320 |
LANGUAGE plpgsql |
|
1321 |
AS $$ |
|
1322 |
BEGIN |
|
1323 |
PERFORM set_config('search_path', util.schema_ident(schema_null), true); |
|
1324 |
PERFORM util.schema_bundle_rm(util.schema_ident(schema_null)); |
|
1325 |
END; |
|
1326 |
$$; |
|
1327 |
|
|
1328 |
|
|
1329 |
-- |
|
1330 |
-- Name: FUNCTION rm(schema_null anyelement); Type: COMMENT; Schema: public; Owner: - |
|
1331 |
-- |
|
1332 |
|
|
1333 |
COMMENT ON FUNCTION rm(schema_null anyelement) IS 'deletes this schema. |
|
1334 |
|
|
1335 |
usage: SELECT public_schema.rm() |
|
1336 |
|
|
1337 |
secure against renamings of the public schema. |
|
1338 |
|
|
1339 |
schema_null: identifies which schema to publish. the default value is usually fine. |
|
1340 |
'; |
|
1341 |
|
|
1342 |
|
|
1343 |
-- |
|
1316 | 1344 |
-- Name: rm_version_suffix(text); Type: FUNCTION; Schema: public; Owner: - |
1317 | 1345 |
-- |
1318 | 1346 |
|
Also available in: Unified diff
schemas/vegbien.sql: added rm(), which deletes this schema