From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug #791: Error when inserting timestamp 2002-10-13 00:00:00 |
Date: | 2002-09-30 18:20:15 |
Message-ID: | 20020930182015.91A034766BE@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jfferson R. Zuchi (zuchi(at)fusionsoftware(dot)com(dot)br) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Error when inserting timestamp 2002-10-13 00:00:00
Long Description
When I try to insert in a field of the type timestamp value 2002-10-13 00:00:00 occurs this value is modified for 2002-10-12 23:00:00
This was detected in normal conditions of use, with the installation standard of version 7.2.2 running in the platforms Linux (Debian) and FreeBSD 4.4 .
This was the gotten result of a test carried through in my server:
fireball=# \dt
List of relations
Name | Type | Owner
------+-------+----------
test | table | postgres
(1 row)
fireball=# \d test
Table "test"
Attribute | Type | Modifier
-----------+--------------------------+----------
cod | integer | not null
data | timestamp with time zone |
Index: test_pkey
fireball=# insert into test (cod, data) values (1, '2002-10-13 00:00:00');
INSERT 911134 1
fireball=# select * from test ;
cod | data
-----+------------------------
1 | 2002-10-12 23:00:00-03 <-------
(1 row)
fireball=#
Ok, Tanks
Jfferson Zuchi
Sample Code
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-30 18:46:37 | Re: Bug #791: Error when inserting timestamp 2002-10-13 00:00:00 |
Previous Message | Tim Knowles | 2002-09-30 15:39:11 | Re: Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT |