Message-Id: <5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be>
Date: Mon, 15 Dec 2003 16:33:21 +0100
To: pgsql-sql@postgresql.org
From: van Elsacker Frans <fve@atbib.be>
Subject: dump and schema
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

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