Re: Tightening binary receive functions
Andrew Gierth <andrew@tao11.riddles.org.uk>
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: lists@jwp.name (James Pye), pgsql-hackers@postgresql.org, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Date: 2009-10-24T20:26:58Z
Lists: pgsql-hackers
>>>>> "James" == James Pye <lists@jwp.name> writes:
James> Is the new date_recv() constraint actually correct?
No, it's not:
regression=# create table x (a date);
CREATE TABLE
regression=# insert into x values ('1999-01-01');
INSERT 0 1
regression=# copy x to '/tmp/tst.dmp' binary;
COPY 1
regression=# copy x from '/tmp/tst.dmp' binary;
ERROR: date out of range
--
Andrew (irc:RhodiumToad)