James William Pye <lists@jwp.name> wrote:
> Need a special case for the infinities as well?
>
> postgres=# create table foo (d date);
> postgres=# INSERT INTO foo VALUES ('infinity');
> postgres=# COPY foo TO '/Users/jwp/foo.copy' WITH BINARY;
> postgres=# COPY foo FROM '/Users/jwp/foo.copy' WITH BINARY;
> ERROR: date out of range
Exactly. Patch attached.
We have special treatments of infinity in timestamp_recv,
but don't have in date_recv.
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center