Re: [HACKERS] create table and default 'now' problem ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] create table and default 'now' problem ?
Date
Msg-id 21636.937923916@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] create table and default 'now' problem ?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Oleg Bartunov <oleg@sai.msu.su> writes:
> Thank you Tom for explanation. It's not very bothered me as far as I have
> many workarounds suggested in mailing list. But I wondering because
> 'now'::text works as expected when I create view

Yes, it's just the context of a DEFAULT expression that has these
problems.  (Actually, it looks like constraints --- CHECK() expressions
--- are handled in the same bogus way, but we don't seem to get as many
gripes about them...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [HACKERS] create table and default 'now' problem ?
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Re: Referential Integrity In PostgreSQL