Revision 12416
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 2281 | 2281 |
CREATE FUNCTION rm_query_group(group_ text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void |
| 2282 | 2282 |
LANGUAGE sql |
| 2283 | 2283 |
AS $_$ |
| 2284 |
SELECT util.drop_relations_like('^_'||util.regexp_quote($1)||'_', $2,
|
|
| 2285 |
force := true/*needed because some query-view-relations depend on others*/) |
|
| 2284 |
SELECT util.drop_relations_like('^(?:~type\.)?_'||util.regexp_quote($1)||'_',
|
|
| 2285 |
$2, force := true/*needed because some query-view-relations depend on others*/)
|
|
| 2286 | 2286 |
$_$; |
| 2287 | 2287 |
|
| 2288 | 2288 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: rm_query_group(): schemas/vegbien.sql: util.drop_relations_like(): also need to drop ~type tables, so that they will be re-created for the new queries of that group