Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql 7.4b2 bug on column defaults? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgsql 7.4b2 bug on column defaults?
Date
Msg-id 16361.1062165838@sss.pgh.pa.us
Whole thread Raw
In response to pgsql 7.4b2 bug on column defaults?  (Giuseppe Tanzilli - CSF <g.tanzilli@gruppocsf.com>)
List pgsql-hackers
Tree view 
Giuseppe Tanzilli - CSF <g.tanzilli@gruppocsf.com> writes:
> create table test2 (i integer, t timestamp default 'now()');

Use "DEFAULT now()".  I'm surprised you didn't get a syntax error from
the above.

> It is a known change or a bug ?

It's an intentional change, yes.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Thomas Schoebel-Theuer
Date:
Subject: Re: Obscure: correctness of lock manager???
Next
From: Robert Treat
Date:
Subject: Re: [GENERAL] before trigger problem