Revision 13471
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1808 | 1808 |
recreate_users_cmds text[] = util.save_drop_views(users); |
| 1809 | 1809 |
BEGIN |
| 1810 | 1810 |
PERFORM util.eval(cmd); |
| 1811 |
PERFORM util.eval(recreate_users_cmds); |
|
| 1811 |
PERFORM util.create_if_not_exists(recreate_cmd) |
|
| 1812 |
FROM unnest(recreate_users_cmds) recreate_cmd; |
|
| 1813 |
/* create_if_not_exists() rather than eval(), because cmd might manually |
|
| 1814 |
re-create a deleted dependent view, causing it to already exist */ |
|
| 1812 | 1815 |
EXCEPTION |
| 1813 | 1816 |
WHEN dependent_objects_still_exist THEN |
| 1814 | 1817 |
IF users IS NOT NULL THEN RAISE; END IF; -- save_drop_views() didn't fix it |
Also available in: Unified diff
bugfix: schemas/util.sql: force_recreate(): recreate_users_cmds: use create_if_not_exists() rather than eval(), because cmd might manually re-create a deleted dependent view, causing it to already exist