Re: [HACKERS] horology and time failures on freebsd/alpha

2003-02-13 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > I'm still getting failure, but it gets weirder: Fixed --- turns out the bug is that timetz_out was scribbling on its input (thereby changing the table) in the --enable-integer-datetimes path. I back-patched the change into 7.3, although I be

Re: [HACKERS] horology and time failures on freebsd/alpha

2003-02-12 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: >> What the heck!!?!?!?! The SELECT statement has somehow edited >> the data in the table or something??? From this point forward, >> the table is all stuffed... Hm, time to dig out the debugger and figure out where the breakage is. Do you w

Re: [HACKERS] horology and time failures on freebsd/alpha

2003-02-12 Thread Christopher Kings-Lynne
Oops - just to clarify I accidentally copied too many INSERTs into the email. The result of the first SELECT is correct compared to the INSERTs that I did. I copied the INSERTs and CREATE TABLE as-is from timetz.sql Chris > -Original Message- > From: Christopher Kings-Lynne [mailto:[EMA

[HACKERS] horology and time failures on freebsd/alpha

2003-02-12 Thread Christopher Kings-Lynne
I'm still getting failure, but it gets weirder: regression=# drop table timetz_tbl; DROP TABLE regression=# CREATE TABLE TIMETZ_TBL (f1 time(2) with time zone); INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT'); CREATE TABLE regression=# regression=# INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT'); INSERT