dump and schema
От | van Elsacker Frans |
---|---|
Тема | dump and schema |
Дата | |
Msg-id | 5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be обсуждение исходный текст |
Ответы |
Re: dump and schema
|
Список | 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
В списке pgsql-sql по дате отправления: