Postgres Pro
Downloads
Home   >   mailing lists

Re: dump and schema - Mailing list pgsql-sql

From Tom Lane
Subject Re: dump and schema
Date
Msg-id 13072.1071505327@sss.pgh.pa.us
Whole thread Raw
In response to dump and schema  (van Elsacker Frans <fve@atbib.be>)
Responses Re: dump and schema  (Olivier Hubaut <olivier@scmbb.ulb.ac.be>)
List pgsql-sql
Tree view 
van Elsacker Frans <fve@atbib.be> writes:
> 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',
>      ....
> );

This does not work anymore in PG 7.4.  You need something like
datumi date DEFAULT CURRENT_DATE,
        regards, tom lane

pgsql-sql by date:

Previous
From: van Elsacker Frans
Date:
Subject: dump and schema
Next
From: pginfo
Date:
Subject: Re: Interest IN problem on 7.4