From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: David B <postgresql@thegatelys.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: In 7.4 ensure you have DEFAULT now () with no spaces
Date: Sat, 19 Jun 2004 14:50:23 -0400
Message-ID: <17939.1087671023@sss.pgh.pa.us> (raw)
In-Reply-To: <200406191425.43379.peter_e@gmx.net>
References: <GOEGKICPFOPNLIEIHGFJEEMMCNAA.postgresql@thegatelys.com>
<200406191425.43379.peter_e@gmx.net>
Peter Eisentraut <peter_e@gmx.net> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter_e@gmx.net, postgresql@thegatelys.com
Subject: Re: In 7.4 ensure you have DEFAULT now () with no spaces
In-Reply-To: <17939.1087671023@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox