From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Barry Stewart <bstewart(at)smyrnacable(dot)net> |
Cc: | Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: FWD: bizarre behavior of 'time' data entry |
Date: | 2001-01-12 17:13:57 |
Message-ID: | 3A5F3B55.47CEA3C3@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Postgresql subtracts one minute from any times I enter into a database:
> mydb=# create table test (timeval time);
> mydb=# insert into test values ('08:30');
> mydb=# select * from test;
> ----------
> 08:29:00
...
> In a later message he says he's running 7.0.2 on "Trustix Secure Linux
> 1.2 (RedHat based)", whatever that is.
> Thomas, did you see this thread on pg-novices? You ever seen behavior
> like this? I'm baffled.
Not sure about the distro, but it is hard to imagine that they got it
more wrong wrt compiler options than has Mandrake (the other platform
with rounding trouble in their default packages).
Barry, can you give more details? How have you build PostgreSQL? We'll
need some help tracking this down, but afaik it will point back to a
build problem on your platform.
- Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-12 17:34:51 | Re: AW: Re: tinterval - operator problems on AIX |
Previous Message | The Hermit Hacker | 2001-01-12 17:11:27 | Re: Bruce Momjian's interview in LWN. |