Project

General

Profile

Download (87 Bytes) Statistics
| Revision:

root/trunk/inputs/.newWorld/newWorldCountries/postprocess.sql

# Date Author Comment
13971 07/10/2014 06:04 PM Aaron Marcuse-Kubitza

fix: inputs/newWorld/: renamed to inputs/.newWorld/ (see issue #940)
11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).
10253 07/11/2013 05:34 AM Aaron Marcuse-Kubitza

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.)
7302 01/18/2013 10:02 AM Aaron Marcuse-Kubitza

Added inputs/newWorld/newWorldCountries/ with postprocess.sql that sets isNewWorld to false wherever it's NULL. (The input table only marks New World countries as true, but doesn't mark non-New World countries as false.)