Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group