Revision 10253
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/newWorld/newWorldCountries/postprocess.sql | ||
|---|---|---|
| 1 |
ALTER TABLE :table ALTER COLUMN "isNewWorld" TYPE boolean |
|
| 2 |
USING COALESCE("isNewWorld", false);
|
|
| 1 |
UPDATE :table SET "isNewWorld" = COALESCE("isNewWorld", false);
|
|
| 2 |
VACUUM ANALYZE :table; |
|
Also available in: Unified diff
bugfix: inputs/newWorld/newWorldCountries/postprocess.sql: use UPDATE statement (followed by VACUUM ANALYZE to remove dead tuples) instead of in-place update (ALTER COLUMN TYPE USING), so that the statement can be run even after the public schema has been installed and its views use the columns. (a view using the columns would normally block an ALTER COLUMN TYPE statement on a referenced column.)