The upsert step failed with
psycopg2.ProgrammingError: type "double" does not exist
It looks like whatever is parsing the table SQL is assuming that the column type won't have any spaces in it. For this particular case, a workaround exists because DOUBLE PRECISION, FLOAT8, and FLOAT are all aliases of each other, but there may be other cases for which this does not hold.
cliu587
commented
8 years ago
The upsert step failed with
psycopg2.ProgrammingError: type "double" does not existIt looks like whatever is parsing the table SQL is assuming that the column type won't have any spaces in it. For this particular case, a workaround exists because DOUBLE PRECISION, FLOAT8, and FLOAT are all aliases of each other, but there may be other cases for which this does not hold.