Re: Tightening binary receive functions - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: Tightening binary receive functions
Date
Msg-id 20100218122759.2355.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: Tightening binary receive functions  (James William Pye <lists@jwp.name>)
List pgsql-hackers
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


Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: NOTIFY/LISTEN on read-only slave?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] possible bug with inheritance?