I am making some progress on cleaning up regression problems on
Linux/Alpha. I have finally got datetimes from causing postgres to SIGFPE
(floating point expections). The secret appears to be to include the
'-mieee' compile option, via the CFLAGS line in template/linuxalpha. I am
not 100% sure what it does, but it has often been recommend by the people
on the axp-redhat list when people are having SIGFPE problems with thier
programs. It doesn't appear to do any harm, and actually one entire test
(reltime) has been totally fixed. I am still getting a few SIGFPE during
the regression tests, but only a small number of the original many.
The major problem at the moment appears to be that while dates
can be instered and selected sucessfully, they are not correct. I insert
'5/20/98' and when I select I get '5/19/98 11:00 MDT'. It appears too
large for it to be a timezone problem, and the local time zone is properly
set to MDT. The same sort of things happens during the regression tests
when the TZ variable is set as directed (PST). I am thinking that there is
some type of round off error or such occuring, but I am having a rough
time following the sequence a date takes from MM, DD, YY format to the
single integer used to store the date interally, and then back out to a
human readable format again. Would some one please outline what is
happening here, and point out any spots that might cause trouble? Thanks!
PS. What is the correct format for a date in an SQL string? I.e.
the format that includes date, time, and timezone?
PPS. I am using the May 15th, 1998 snapshot still. I doubt that
updating would do me a lot of good at the moment.
----------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
----------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | rkirkpat@nag.cs.colorado.edu |
----------------------------------------------------------------------------
| http://www-ugrad.cs.colorado.edu/~rkirkpat/ |
----------------------------------------------------------------------------
