Re: FWD: bizarre behavior of 'time' data entry

Check out Trustix at www.trustix.net. I'm using the RPM that was installed
with the distro.

ps shows postgresql running:

/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster start
/usr/bin/postmaster -i

I can poke a hole in my firewall and let you connect to the database if you
would like troubleshoot my sytem. But I'll need some help setting up
permissions to allow external connections. Let me know and I'll send my IP
address to your private email.

Also, let me know what particular build problems might cause this, and I'll
post to Trustix mail list.

Thanks for you help,

Barry

On 2001.01.12 12:13:57 -0500 Thomas Lockhart wrote:
> > 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
>