X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B3B6ED1DBC8 for ; Tue, 16 Dec 2003 09:25:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 99855-08 for ; Tue, 16 Dec 2003 05:24:40 -0400 (AST) Received: from bonito.ulb.ac.be (mailhost.ulb.ac.be [164.15.59.220]) by svr1.postgresql.org (Postfix) with ESMTP id 232B6D1B53E for ; Tue, 16 Dec 2003 05:24:37 -0400 (AST) Received: from mach.vub.ac.be (mach.ulb.ac.be [164.15.128.3]) by bonito.ulb.ac.be (8.8.8/3.17.1.ap (resu)) id KAA15899; Tue, 16 Dec 2003 10:23:54 +0100 (MET) for Received: from scmbb.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (8.9.3/3.13.5.aejp (mach)) id KAA02155; Tue, 16 Dec 2003 10:24:27 +0100 (MET) for Message-ID: <3FDED01A.8090009@scmbb.ulb.ac.be> Date: Tue, 16 Dec 2003 10:27:54 +0100 From: Olivier Hubaut User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: van Elsacker Frans , pgsql-sql@postgresql.org Subject: Re: dump and schema References: <5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be> <13072.1071505327@sss.pgh.pa.us> In-Reply-To: <13072.1071505327@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/111 X-Sequence-Number: 16277 Tom Lane wrote: > van Elsacker Frans 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 > I think this won't get the same result he expects. As I know, the CURRENT_DATE will always give the current day, not the day you inserted the row. I think the now()::date seems to be a better way to translate the 'today' value. -- Ci-git une signature avortee. ** RIP **