Postgres Pro
Downloads
Home   >   mailing lists

BUG #1938: pg_dump mis-intreprets "default now()"; - Mailing list pgsql-bugs

From Jeff MacDonald
Subject BUG #1938: pg_dump mis-intreprets "default now()";
Date
Msg-id 20051004192923.8662BF11A0@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1938: pg_dump mis-intreprets "default now()";
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1938
Logged by:          Jeff MacDonald
Email address:      jeff@interchange.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.

pgsql-bugs by date:

Previous
From: Steve Peterson
Date:
Subject: Re: Bug?: Text after right paren in query is ignored
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #1938: pg_dump mis-intreprets "default now()";