| 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: | Whole Thread | Raw Message | 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 |