Revision 8323
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 702 | 702 |
EXECUTE mk_view; |
| 703 | 703 |
EXCEPTION |
| 704 | 704 |
WHEN invalid_table_definition THEN |
| 705 |
IF SQLERRM = 'cannot drop columns from view' THEN |
|
| 705 |
IF SQLERRM = 'cannot drop columns from view' |
|
| 706 |
OR SQLERRM LIKE 'cannot change name of view column "%" to "%"' |
|
| 707 |
THEN |
|
| 706 | 708 |
EXECUTE $$DROP VIEW $$||view_||$$ CASCADE$$; |
| 707 | 709 |
EXECUTE mk_view; |
| 708 | 710 |
ELSE RAISE USING ERRCODE = SQLSTATE, MESSAGE = SQLERRM; |
Also available in: Unified diff
schemas/util.sql: force_update_view(): Fixed bug where also need to drop view for "cannot change name of view column" errors