X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EB9DCD1B1F8 for ; Sat, 19 Jun 2004 15:50:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09737-01 for ; Sat, 19 Jun 2004 18:50:26 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1880DD1B188 for ; Sat, 19 Jun 2004 15:50:24 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5JIoNJ8017941; Sat, 19 Jun 2004 14:50:23 -0400 (EDT) To: Peter Eisentraut Cc: "David B" , pgsql-sql@postgresql.org Subject: Re: In 7.4 ensure you have DEFAULT now () with no spaces In-reply-to: <200406191425.43379.peter_e@gmx.net> References: <200406191425.43379.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Sat, 19 Jun 2004 14:25:43 +0200" Date: Sat, 19 Jun 2004 14:50:23 -0400 Message-ID: <17939.1087671023@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/166 X-Sequence-Number: 18111 Peter Eisentraut writes: > David B wrote: >> Looking at those tables the create DDL's for those few tables >> contained now () >> as in: >> >> created_timestamp timestamp DEFAULT now () -- note the space >> between now and () > Whatever it was, that was not the problem. With 7.4.1: Nope. I suppose this was a garbled report of the problem with default 'now' as opposed to default now() The timestamp input parser will take 'now()' and variants on that, since it basically ignores punctuation. So probably what was really at stake was default 'now()' (wrong because a string literal) versus default now() (correct because a function call). regards, tom lane