Bug report?
Sue <sue@newel.net>
From: Sue <sue@newel.net>
To: webmaster@postgresql.org
Date: 1999-09-13T13:42:13Z
Lists: pgsql-bugs
Hello,
As a novice user of PostreSQL, I try to make a backup of my database
regularly. I used the pg_dump command and found that my dump file is
not what I expected.
I have a column type : last_modified DATE NOT NULL DEFAULT CURRENT_DATE
When I pg_dump this I get the following line in my file :
"last_modified" date DEFAULT date( 'current'::datetime + '0 sec')
NOT NULL,
When I try to reload the table, it seems to block. After I change this
line back to what I had originally, it seems to load fine. Is this
really a bug or am I doing something wrong?
Thank you for your time.
Sincerely,
Sue Harbour