timestamptz test failed by postgresql 6.5.0

From: yangtao <yangtaoyours(at)126(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: timestamptz test failed by postgresql 6.5.0
Date: 2021-01-04 05:52:01
Message-ID: 59c4bbda.277f.176cbf3cda7.Coremail.yangtaoyours@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Recently, I compile the Postgresql 9.6.0 on Linux by myself. However, I meet one problem about the timestamptz.sql test case.
The expected timestamptz.out is different from the result of timestamptz.out for ime zone America/Caracas and
America/Santiago

Part of expected timestamptz.out :
DROP TABLE TIMESTAMPTZ_TST;
-- test timestamptz constructors
set TimeZone to 'America/Santiago';
-- numeric timezone
SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33);
make_timestamptz
---------------------------------
Sun Jul 15 08:15:55.33 1973 CLT
(1 row)

SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '+2');
make_timestamptz
---------------------------------
Sun Jul 15 02:15:55.33 1973 CLT

Part of the result timestamptz.out :
DROP TABLE TIMESTAMPTZ_TST;
-- test timestamptz constructors
set TimeZone to 'America/Santiago';
-- numeric timezone
SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33);
make_timestamptz
---------------------------------
Sun Jul 15 08:15:55.33 1973 -04
(1 row)

SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '+2');
make_timestamptz
---------------------------------
Sun Jul 15 02:15:55.33 1973 -04

I don't why the timezone in the output "CLT" becomes "-04" in the output. Could anyone please give me some idea to find the trouble cause?
Thanks!

Best Regards!
Tao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-01-04 06:07:39 Re: timestamptz test failed by postgresql 6.5.0
Previous Message Jack Orenstein 2021-01-04 04:41:08 Re: Crashing on insert to GIN index