Revision 12547
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 2332 | 2332 |
COMMENT ON FUNCTION rm_all_queries(schema text, schema_anchor anyelement) IS ' |
| 2333 | 2333 |
removes all validations queries in a specific schema, or in all schemas |
| 2334 | 2334 |
|
| 2335 |
**WARNING**: if schema = ''public_validations'', this removes in *all* schemas, |
|
| 2336 |
not just public_validations. this is because this uses rm_query_view(). |
|
| 2337 |
|
|
| 2335 | 2338 |
usage: |
| 2336 | 2339 |
SELECT public_validations.rm_all_queries(''datasource'');
|
| 2337 | 2340 |
|
| 2338 | 2341 |
idempotent |
| 2339 | 2342 |
|
| 2340 |
schema: if NULL, operates on all schemas |
|
| 2343 |
schema: if NULL or ''public_validations'', operates on all schemas
|
|
| 2341 | 2344 |
schema_anchor: identifies this function''s schema. should be left as the default. |
| 2342 | 2345 |
'; |
| 2343 | 2346 |
|
Also available in: Unified diff
schemas/vegbien.sql: rm_all_queries(schema): documented this function's unexpected behavior when schema = public_validations (it removes in all schemas, not just public_validations). this is because this uses rm_query_view().