Revision 13451
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1791 | 1791 |
IF users IS NOT NULL THEN RAISE; END IF; -- save_drop_views() didn't fix it |
| 1792 | 1792 |
GET STACKED DIAGNOSTICS PG_EXCEPTION_DETAIL = PG_EXCEPTION_DETAIL; |
| 1793 | 1793 |
users = array(SELECT * FROM util.regexp_matches_group( |
| 1794 |
PG_EXCEPTION_DETAIL, '(?m)^view (.*) depends on [:lower:]+ .*$'));
|
|
| 1794 |
PG_EXCEPTION_DETAIL, '(?m)^view (.*) depends on [[:lower:]]+ .*$'));
|
|
| 1795 | 1795 |
PERFORM util.debug_print_var('PG_EXCEPTION_DETAIL', PG_EXCEPTION_DETAIL);
|
| 1796 | 1796 |
PERFORM util.debug_print_var('users', users);
|
| 1797 | 1797 |
IF util.is_empty(users) THEN RAISE; END IF; |
Also available in: Unified diff
bugfix: schemas/util.sql: force_recreate(): need to use :lower:, not [:lower:]