pgsql-bugs(at)postgresql(dot)org writes:
> inability to restore infinity values via psql or pg_restore
I don't think this has anything to do with a dump/restore problem.
What it is is a problem with dealing with overflow in timestamp
calculations.
In current sources:
regression=# select timestamp 'infinity' - timestamp '-infinity';
?column?
---------------------------------------------
2147483647 days 2147483647:2147483647:00inf
(1 row)
AFAICT we don't have a concept of "infinity" for intervals, so this
should raise an error instead of returning a bogus value.
regards, tom lane