pgsql 7.4b2 bug on column defaults?

From: Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pgsql 7.4b2 bug on column defaults?
Date: 2003-08-29 09:34:11
Message-ID: 3F4F1E13.2010208@gruppocsf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
just testing beta2 I got strange things on default values with functions:

create table test2 (i integer, t timestamp default 'now()');

test1=# \d test2
Table "public.test2"
Column | Type |
Modifiers
--------+-----------------------------+-------------------------------------------------------------------
i | integer |
t | timestamp without time zone | default '29/08/2003
11:26:23.937421'::timestamp without time zone

test1=# insert into test2 values(1);
INSERT 9841455 1
test1=# insert into test2 values(1);
INSERT 9841456 1
test1=# insert into test2 values(1);
INSERT 9841457 1

test1=# select * from test2;
i | t
---+----------------------------
1 | 29/08/2003 11:26:23.937421
1 | 29/08/2003 11:26:23.937421
1 | 29/08/2003 11:26:23.937421
(3 rows)

Seems that functions are valuated when the table is created,
It is a known change or a bug ?

thanks,
Giuseppe

--
-------------------------------------------------------
Giuseppe Tanzilli g(dot)tanzilli(at)gruppocsf(dot)com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Giuseppe Tanzilli - CSF Sistemi 2003-08-29 10:02:21 Re: pgsql 7.4b2 bug on column defaults?
Previous Message Andreas Pflug 2003-08-29 08:25:45 Re: Weird constraint output