Re: [BUGS] BUG #1938: pg_dump mis-intreprets "default now()";

2005-10-06 Thread Jeff MacDonald
Thanks ! Jeff. Michael Fuhr wrote: On Tue, Oct 04, 2005 at 08:29:23PM +0100, Jeff MacDonald wrote: 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. Mean

Re: [BUGS] BUG #1938: pg_dump mis-intreprets "default now()";

2005-10-05 Thread Michael Fuhr
On Tue, Oct 04, 2005 at 08:29:23PM +0100, Jeff MacDonald wrote: > 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 inst

[BUGS] BUG #1938: pg_dump mis-intreprets "default now()";

2005-10-04 Thread Jeff MacDonald
The following bug has been logged online: Bug reference: 1938 Logged by: Jeff MacDonald Email address: [EMAIL PROTECTED] 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