| 4511 |
4511 |
-- Name: rm_output_queries(text, integer, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 4512 |
4512 |
--
|
| 4513 |
4513 |
|
| 4514 |
|
CREATE FUNCTION rm_output_queries(prefix text DEFAULT NULL::text, max_prefix_len integer DEFAULT query_view_relation_max_prefix_len(), schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void
|
|
4514 |
CREATE FUNCTION rm_output_queries(name text DEFAULT NULL::text, max_prefix_len integer DEFAULT query_view_relation_max_prefix_len(), schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void
|
| 4515 |
4515 |
LANGUAGE sql
|
| 4516 |
4516 |
AS $_$
|
| 4517 |
|
SELECT util.drop_relations_like('^(?:\w*~type\.)?'||
|
| 4518 |
|
COALESCE(util.regexp_quote(util.truncated_prefixed_name_regexp($1, $2)),
|
| 4519 |
|
'_[[:alpha:]]+_'),
|
|
4517 |
SELECT util.drop_relations_like(
|
|
4518 |
COALESCE(util.truncated_prefixed_name_regexp($1, $2), '_[[:alpha:]]+_'),
|
| 4520 |
4519 |
$3, force := true/*needed because some query-view-relations depend on others*/)
|
| 4521 |
4520 |
$_$;
|
| 4522 |
4521 |
|
| 4523 |
4522 |
|
| 4524 |
4523 |
--
|
| 4525 |
|
-- Name: FUNCTION rm_output_queries(prefix text, max_prefix_len integer, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -
|
|
4524 |
-- Name: FUNCTION rm_output_queries(name text, max_prefix_len integer, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -
|
| 4526 |
4525 |
--
|
| 4527 |
4526 |
|
| 4528 |
|
COMMENT ON FUNCTION rm_output_queries(prefix text, max_prefix_len integer, schema_anchor anyelement) IS '
|
|
4527 |
COMMENT ON FUNCTION rm_output_queries(name text, max_prefix_len integer, schema_anchor anyelement) IS '
|
| 4529 |
4528 |
removes validations *output* queries (in this function''s schema)
|
| 4530 |
4529 |
|
| 4531 |
4530 |
note that this will cascadingly drop all result tables for those queries as well
|
| ... | ... | |
| 4536 |
4535 |
to remove all output queries:
|
| 4537 |
4536 |
SELECT public_validations.rm_output_queries();
|
| 4538 |
4537 |
|
| 4539 |
|
to remove output queries with a particular group prefix:
|
| 4540 |
|
SELECT public_validations.rm_output_queries(''_group_'');
|
| 4541 |
|
|
| 4542 |
4538 |
to remove a particular output query:
|
| 4543 |
4539 |
SELECT public_validations.rm_output_queries(''_view_name'');
|
| 4544 |
4540 |
|
bugfix: schemas/vegbien.sql: rm_output_queries(): need to account for the fact that util.truncated_prefixed_name_regexp() returns a whole-string regexp. this drops support for removing output queries with a particular group prefix, which we no longer use.