> 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
