Revision 13604
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 3085 | 3085 |
restore_views_info = util.save_drop_views(users); |
| 3086 | 3086 |
|
| 3087 | 3087 |
-- trigger the dependent_objects_still_exist exception |
| 3088 |
PERFORM util.eval(util.mk_drop_from_create(cmd));
|
|
| 3088 |
PERFORM util.eval(COALESCE(util.mk_drop_from_create(cmd), '')||cmd);
|
|
| 3089 | 3089 |
-- *not* CASCADE; it must trigger an exception |
| 3090 | 3090 |
|
| 3091 |
PERFORM util.eval(cmd); |
|
| 3092 |
|
|
| 3093 | 3091 |
PERFORM util.restore_views(restore_views_info); |
| 3094 | 3092 |
EXCEPTION |
| 3095 | 3093 |
WHEN dependent_objects_still_exist THEN |
Also available in: Unified diff
bugfix: schemas/util.sql: recreate(): need to handle case where util.mk_drop_from_create() is NULL