Jéfferson R. Zuchi ([EMAIL PROTECTED]) 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
Jéfferson Zuchi
Sample Code
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
