Revision 13445
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1765 | 1765 |
IF users IS NOT NULL THEN RAISE; END IF; -- save_drop_views() didn't fix it |
| 1766 | 1766 |
GET STACKED DIAGNOSTICS PG_EXCEPTION_DETAIL = PG_EXCEPTION_DETAIL; |
| 1767 | 1767 |
users = array(SELECT * FROM util.regexp_matches_group( |
| 1768 |
PG_EXCEPTION_DETAIL, '(?m)^view (.*) depends on table .*$'));
|
|
| 1768 |
PG_EXCEPTION_DETAIL, '(?m)^view (.*) depends on [:lower:]+ .*$'));
|
|
| 1769 | 1769 |
IF util.is_empty(users) THEN RAISE; END IF; |
| 1770 | 1770 |
PERFORM util.force_recreate(cmd, users); |
| 1771 | 1771 |
END; |
Also available in: Unified diff
fix: schemas/util.sql: util.force_recreate(): also support dropping things besides tables