Re: [HACKERS] timestamp bug?

2003-07-17 Thread Tom Lane 
Gavin Sherry <[EMAIL PROTECTED]> writes:
> Shouldn't we be detecting problems with the following (haven't seen
> mention of it):
> template1=# insert into b values('1000-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 '1000-12-01 23:23:23'::timestamp;
ERROR:  TIMESTAMP out of range '1000-12-01 23:23:23'
regression=# select '1000-12-01 23:23:23'::timestamptz;
ERROR:  TIMESTAMP WITH TIME ZONE out of range '1000-12-01 23:23:23'

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[HACKERS] timestamp bug?

2003-06-25 Thread Gavin Sherry 
Shouldn't we be detecting problems with the following (haven't seen
mention of it):

template1=# insert into b values('1000-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


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings