Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-12 Thread Zeugswetter Andreas SB SD
> I have removed the NO_MKTIME_BEFORE_1970 symbol from irix5.h, > rebuilt 7.3b2, and reran the regression. The three time tests > (tinterval, horology, abstime) now match the Solaris expected files. > I checked the timezone files, and the system does not appear to > have savings time d

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-11 Thread Robert E. Bruccoleri
Dear Tom, I have removed the NO_MKTIME_BEFORE_1970 symbol from irix5.h, rebuilt 7.3b2, and reran the regression. The three time tests (tinterval, horology, abstime) now match the Solaris expected files. I checked the timezone files, and the system does not appear to have savings tim

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-09 Thread Tom Lane
"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > There are differences in the regression tests for PostgreSQL > 7.3b2 with handling of times before 1970. I recently sent out a set of > diffs for the changes. I've looked through the datetime.c code, but > it's not obvious to me what the cause of

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-08 Thread Robert E. Bruccoleri
Dear Tom, Here's the result of your queries: template1=# set TimeZone TO 'PST8PDT'; SET template1=# select abstime 'May 10, 1947 23:59:12'; abstime 1947-05-10 22:59:12-08 (1 row) template1=# select (abstime 'May 10, 1947 23:59:12')::int4; int4 ---

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-08 Thread Tom Lane
"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > There are differences in the regression tests for PostgreSQL > 7.3b2 with handling of times before 1970. I recently sent out a set of > diffs for the changes. I've looked through the datetime.c code, but > it's not obvious to me what the ca

[HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-08 Thread Robert E. Bruccoleri
Dear All, There are differences in the regression tests for PostgreSQL 7.3b2 with handling of times before 1970. I recently sent out a set of diffs for the changes. I've looked through the datetime.c code, but it's not obvious to me what the cause of the change is. PostgreSQL 7.2 works fine