postgres issues with doubles about myria-web HOT 3 CLOSED

@domoritz as the postgres admin
@7andrew7 as the person who has experience dealing with the shit show that doubles induce

from myria-web.

I have no special insight; that number is well within range, as doubles have 11 exponent bits.

I just checked that a C program can ingest that number; no problem:

double c = 4.9E-324;

from myria-web.

It's a denormalized double and postgres doesn't handle those well. I'm still at a loss to see how printing the double doesn't let us put it back in the database.. however I was able to work around the issue by long-circuiting @domoritz 's COPY trick when there are doubles or floats present.

uwescience/myria@ae78e66

There is also a binary copy we should check out if this is something we want to pursue.

from myria-web.