From: van Elsacker Frans <fve@atbib.be>
To: pgsql-sql@postgresql.org
Subject: dump and schema
Date: Mon, 15 Dec 2003 16:33:21 +0100
Message-ID: <5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be> (raw)
I have a problem with date default and schema's and don't know wether I am
doing something wrong or not.
All my tables (more than 100) have a field datumi of type date default
today, as this example:
CREATE TABLE tabel (
....
datumi date DEFAULT 'today',
....
);
taking a dump or a schema of this table via pg_dump and restoring or using
it went fine
Now I am using postgres 7.4 and making a schema (and also the table in a
dump gave this result)
CREATE TABLE tabel(
....
datumi date DEFAULT '2003-12-10'::date,
....
);
which is not expected for a schema. Even worse by restoring a dump, all my
new records have this fixed date in the field datumi.
Something has changed? I do it in the wrong way? Is there a solution ?
many thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fve@atbib.be
Subject: Re: dump and schema
In-Reply-To: <5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox