Revision 13450
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1792 | 1792 |
GET STACKED DIAGNOSTICS PG_EXCEPTION_DETAIL = PG_EXCEPTION_DETAIL; |
| 1793 | 1793 |
users = array(SELECT * FROM util.regexp_matches_group( |
| 1794 | 1794 |
PG_EXCEPTION_DETAIL, '(?m)^view (.*) depends on [:lower:]+ .*$')); |
| 1795 |
PERFORM util.debug_print_var('PG_EXCEPTION_DETAIL', PG_EXCEPTION_DETAIL);
|
|
| 1796 |
PERFORM util.debug_print_var('users', users);
|
|
| 1795 | 1797 |
IF util.is_empty(users) THEN RAISE; END IF; |
| 1796 | 1798 |
PERFORM util.force_recreate(cmd, users); |
| 1797 | 1799 |
END; |
Also available in: Unified diff
schemas/util.sql: force_recreate(): debug-print PG_EXCEPTION_DETAIL, users to assist in debugging