From: | van Elsacker Frans <fve(at)atbib(dot)be> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | dump and schema |
Date: | 2003-12-15 15:33:21 |
Message-ID: | 5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | pginfo | 2003-12-15 15:53:29 | Re: Interest IN problem on 7.4 |
Previous Message | Michael Shapiro | 2003-12-14 09:52:48 | arrays in pl/pgsql |