Shouldn't we be detecting problems with the following (haven't seen
mention of it):

template1=# insert into b values('10000000-12-01 23:23:23');
INSERT 555183 1
template1=# select * from b;
ERROR:  Unable to format timestamp; internal coding error

Tested on reasonably recent CVS.

Mentioned on IRC.

Thanks,

Gavin


Wed, 25 Jun 2003 23:37:51 +1000 (EST)
Gavin Sherry <swm@linuxworld.com.au>
timestamp bug?
Gavin Sherry <swm@linuxworld.com.au> writes:
> Shouldn't we be detecting problems with the following (haven't seen
> mention of it):
> template1=# insert into b values('10000000-12-01 23:23:23');
> INSERT 555183 1
> template1=# select * from b;
> ERROR:  Unable to format timestamp; internal coding error

Okay, now I get

regression=# select '10000000-12-01 23:23:23'::timestamp;
ERROR:  TIMESTAMP out of range '10000000-12-01 23:23:23'
regression=# select '10000000-12-01 23:23:23'::timestamptz;
ERROR:  TIMESTAMP WITH TIME ZONE out of range '10000000-12-01 23:23:23'

			regards, tom lane

Thu, 17 Jul 2003 18:30:30 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: timestamp bug? 