Project

General

Profile

« Previous | Next » 

Revision 10253

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.)

View differences:

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