Re: Problem with COPY in 8.0.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Problem with COPY in 8.0.3
Date
Msg-id 4415.1129153688@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with COPY in 8.0.3  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Michael Fuhr <mike@fuhr.org> writes:
> On Wed, Oct 12, 2005 at 08:23:15PM +0100, Oliver Elphick wrote:
>> I actually use CURRENT_DATE; that is what the system turns it into.

> Ah yes, I see that now.  I generally use now(), so I hadn't noticed
> that CURRENT_DATE and CURRENT_TIMESTAMP become 'now', whereas only
> a literal 'now' is expanded at create time:

Yeah.  That implementation of CURRENT_TIMESTAMP and friends is
historical, and probably ought to be changed sometime.  It works OK
but it's ugly, especially for reverse-listing purposes.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with COPY in 8.0.3
Next
From: Jaime Casanova
Date:
Subject: Re: BUG #1953: trigger action on delete