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

From Andrew Gierth
Subject Re: Tightening binary receive functions
Date
Msg-id 873a58edwt.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Tightening binary receive functions  (James Pye <lists@jwp.name>)
Responses Re: Tightening binary receive functions  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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)


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: pre-proposal: type interfaces
Next
From: Robert Haas
Date:
Subject: Re: Parsing config files in a directory