Re: dump and schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: van Elsacker Frans <fve(at)atbib(dot)be>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: dump and schema
Date: 2003-12-15 16:22:07
Message-ID: 13072.1071505327@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

van Elsacker Frans <fve(at)atbib(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Prashant Dalal 2003-12-15 17:14:17 NOT-IN CLAUSE
Previous Message pginfo 2003-12-15 15:53:29 Re: Interest IN problem on 7.4