POSTGRESQL BUG REPORT
TEMPLATE
Your
name
: Nayib KiuhanYour email address : [EMAIL PROTECTED]
On Oct-15 2003, Wed, 02:08 -0400
Nayib Kiuhan <[EMAIL PROTECTED]> wrote:
> "date" timestamp DEFAULT 'now'
I believe you should be using
"date" timestampt DEFAULT CURRENT_TIMESTAMP(0)
--
Tomas Szepe <[EMAIL PROTECTED]>
---(end of broadcast)
On Wed, 2003-10-15 at 02:08, Nayib Kiuhan wrote:
> In versions before 7.4beta3 I use to have tables with
> "date" timestamp DEFAULT 'now'
> It use to works properly, placing the actual date at the moment a new
> record was inserted. Now it always have the same date which correspond
> to the d
On Wed, 2003-10-15 at 13:29, Nayib Kiuhan wrote:
> It is a good idea to through out an error during the table creation if
> the format is not as indicated (now()), because when I created my
> tables with the old format, it did not show any problem
I agree that this kind of silent backward-incompat
Neil Conway <[EMAIL PROTECTED]> writes:
> I agree that this kind of silent backward-incompatibility isn't good,
It's unpleasant, but we were going to have to bite this bullet sooner or
later. Allowing 'now' to work like a non-constant in this context was
always a fragile hack.
> Tom, can we impr