Thread: pg_dupp/pg_dumpall problem!

pg_dupp/pg_dumpall problem!

From
Lehel Gyuro
Date:
Hi!

I've noticed a pg_dump/pg_dumpall problem with timestamp variables, in
dumping the minute, and second values:
instead of dumping
12:01:00.00 it dumps out 12:60:00.00 which is not accepted when
restoring a database...

Gyuro Lehel




Re: pg_dupp/pg_dumpall problem!

From
Thomas Lockhart
Date:
> I've noticed a pg_dump/pg_dumpall problem with timestamp variables, in
> dumping the minute, and second values:
> instead of dumping
> 12:01:00.00 it dumps out 12:60:00.00 which is not accepted when
> restoring a database...

You are running the Mandrake distro, or somehow compiling with a bad set
of mixed-up compiler flags. You need to *not* compile with -ffast-math,
but rather with -O2 or -O3 only.
                      - Thomas