Re: [PORTS] Port Bug Report: pg_dump(all) fails to create usable "restore" file

> Summary: pg_dump(all) fails to create usable "restore" file
>   Operating System   : Linux 2.0.36 ELF
>   PostgreSQL version : 6.3.2
> Problem Description:
> --------------------
> 1.  pg_dump(all) doesn't handle table constraints properly
> on output...the "create table" command won't parse properly.

v6.4 has some improvements in this area. As you've found, it isn't
handled quite right in v6.3.2.

> 2.  pg_dump will create times of the type "01:04:60.00"...
> not "01:05:00.00".  These create error on subsequent
> "copy tbl from STDIN" commands

Hmm. Your system is close to my linux-2.0.30/libc5/gcc-2.7.x system
(though you might be running glibc2). The time strings are formatted in
the backend, so pg_dump does not have a direct effect on the format. Do
you see this in other uses of the date/time types? I recall that some of
the original RedHat glibc2 rpms had a bit of trouble with rounding, but
that it was fixed around glibc-2.0.7.

                   - Tom