CODEWITHSUNDEEP
postgresqlcentos
Michal Janicek
Michal Janicek

Reputation: 11

Issue with Postgresql 13.0 compilation on CentOS 8,7 on check timetz

if anyone have some experience with compilation of Postgresql 13.0 from source on platform Centos 7,8 , and would you feel free to share the knowledges, please help me. On both version I had problem with check "timetz" looks like:

...
    date                         ... ok         1948 ms
    time                         ... ok         1613 ms
    timetz                       ... FAILED     1631 ms
    timestamp                    ... ok         2133 ms
    timestamptz                  ... ok         2397 ms
    interval                     ... ok         2197 ms
    inet                         ... ok         2153 ms
...

I tried to change timezone to UTC etc. but without success. Maybe I totally wrong. If you know what is wrong, please let me know the hint or help.

Thanks folks!

Add to debug: file: /home/release/src/postgresql-13.0/src/test/regress/results/timetz.out

SELECT '24:00:00.01'::timetz;  -- not allowed
ERROR:  date/time field value out of range: "24:00:00.01"
LINE 1: SELECT '24:00:00.01'::timetz;
               ^
SELECT '23:59:60.01'::timetz;  -- not allowed
ERROR:  date/time field value out of range: "23:59:60.01"
LINE 1: SELECT '23:59:60.01'::timetz;
               ^
SELECT '24:01:00'::timetz;  -- not allowed
ERROR:  date/time field value out of range: "24:01:00"
LINE 1: SELECT '24:01:00'::timetz;
               ^
SELECT '25:00:00'::timetz;  -- not allowed
ERROR:  date/time field value out of range: "25:00:00"
LINE 1: SELECT '25:00:00'::timetz;
               ^
--
-- TIME simple math
--
-- We now make a distinction between time and intervals,
-- and adding two times together makes no sense at all.
-- Leave in one query to show that it is rejected,
-- and do the rest of the testing in horology.sql
-- where we do mixed-type arithmetic. - thomas 2000-12-02
SELECT f1 + time with time zone '00:01' AS "Illegal" FROM TIMETZ_TBL;
ERROR:  operator does not exist: time with time zone + time with time zone
LINE 1: SELECT f1 + time with time zone '00:01' AS "Illegal" FROM TI...
                  ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

Upvotes: 0

Views: 121

Answers (1)

Adrian Klaver
Adrian Klaver

Reputation: 19684

A bug has been filed, see here. Should be fixed in next minor release.

Upvotes: 1

Related Questions