| 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: | Whole Thread | Raw Message | 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
| 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 |