Re: Tightening binary receive functions

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: lists(at)jwp(dot)name (James Pye), pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Subject: Re: Tightening binary receive functions
Date: 2009-10-24 20:26:58
Message-ID: 873a58edwt.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "James" == James Pye <lists(at)jwp(dot)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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-10-24 21:10:23 Re: Parsing config files in a directory
Previous Message Dimitri Fontaine 2009-10-24 20:10:43 Re: pre-proposal: type interfaces