Revision 12524
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 2360 | 2360 |
PERFORM util.use_schema(schema_anchor); |
| 2361 | 2361 |
|
| 2362 | 2362 |
PERFORM rm_query_view(view_, schema_anchor) |
| 2363 |
-- rm_query_view('public_validations.view') searches *all* schemas
|
|
| 2363 | 2364 |
FROM validation_views(COALESCE(schema, util.schema(schema_anchor))) view_ |
| 2364 | 2365 |
; |
| 2365 | 2366 |
END; |
| ... | ... | |
| 2371 | 2372 |
-- |
| 2372 | 2373 |
|
| 2373 | 2374 |
COMMENT ON FUNCTION rm_all_queries(schema text, schema_anchor anyelement) IS ' |
| 2374 |
removes all validations queries in a specific schema, or in this function''s |
|
| 2375 |
schema |
|
| 2375 |
removes all validations queries in a specific schema, or in all schemas |
|
| 2376 | 2376 |
|
| 2377 | 2377 |
usage: |
| 2378 | 2378 |
SELECT public_validations.rm_all_queries(''datasource'');
|
| 2379 | 2379 |
|
| 2380 | 2380 |
idempotent |
| 2381 | 2381 |
|
| 2382 |
schema: if NULL, operates on this function''s schema
|
|
| 2382 |
schema: if NULL, operates on all schemas
|
|
| 2383 | 2383 |
schema_anchor: identifies this function''s schema. should be left as the default. |
| 2384 | 2384 |
'; |
| 2385 | 2385 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: rm_all_queries(): documented that this actually does remove queries in all schemas when schema is NULL, because rm_query_view(public_validations.view) searches all schemas