The following bug has been logged online:
Bug reference: 1938
Logged by: Jeff MacDonald
Email address: jeff(at)interchange(dot)ca
PostgreSQL version: 8.0.3
Operating system: FreeBSD 5.2.1
Description: pg_dump mis-intreprets "default now()";
Details:
Hi,
I did a backup from 7.3.2 using pg_dumpall.
When I did a restore all of my timestamps that were defaulted to now(); were
now defaulted to the time that I piped my dump back into postgres.
Meaning the now() was parsed instead of just being copied.