Revision 12669
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 3540 | 3540 |
CREATE FUNCTION rm_output_queries(group_ text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void |
| 3541 | 3541 |
LANGUAGE sql |
| 3542 | 3542 |
AS $_$ |
| 3543 |
SELECT util.drop_relations_like('^(?:~type\.)?_'||
|
|
| 3543 |
SELECT util.drop_relations_like('^(?:\w*~type\.)?_'||
|
|
| 3544 | 3544 |
COALESCE(util.regexp_quote($1), '[[:alpha:]]+') ||'_', |
| 3545 | 3545 |
$2, force := true/*needed because some query-view-relations depend on others*/) |
| 3546 | 3546 |
$_$; |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: rm_output_queries(): also need to include keys_* and values__* types, as these are also associated with the query