Re: pgsql 7.4b2 bug on column defaults?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql 7.4b2 bug on column defaults?
Date: 2003-08-29 14:03:58
Message-ID: 16361.1062165838@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-29 14:05:08 Re: Hardware recommendations to scale to silly load
Previous Message Thomas Schoebel-Theuer 2003-08-29 14:01:54 Re: Obscure: correctness of lock manager???