| From: | Uwe Sauter <uwe(dot)sauter(dot)de(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | timetz does not recognize localized timezone names (tested on v14 to v18) |
| Date: | 2026-11-19 18:37:47 |
| Message-ID: | 82176154-91ce-4912-95fd-a442488e74ce@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear PostgreSQL developers,
I think I stumbled upon a minor bug during a course I took this week.
This is on Debian 13.7 Trixie with up-to-date PostgreSQL versions 14 to 18.
The timetz data type does not recognize the geographical descriptions of time zones.
#### snip ####
postgres(at)test:~$ pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
14 main 5436 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
15 main 5435 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
16 main 5434 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log
17 main 5433 online postgres /var/lib/postgresql/17/main /var/log/postgresql/postgresql-17-main.log
18 main 5432 online postgres /var/lib/postgresql/18/main /var/log/postgresql/postgresql-18-main.log
postgres(at)test:~$ for port in $(pg_lsclusters | awk '/main/ {print $3}'); do echo "create database
test;" | psql -p $port; echo "create table mytest (testtime timetz); insert into mytest values
('8:00 CET'); insert into mytest values ('9:00 Europe/Berlin');" | psql -p $port; done
CREATE DATABASE
CREATE TABLE
INSERT 0 1
ERROR: invalid input syntax for type time with time zone: "9:00 Europe/Berlin"
LINE 1: insert into mytest values ('9:00 Europe/Berlin');
^
CREATE DATABASE
CREATE TABLE
INSERT 0 1
ERROR: invalid input syntax for type time with time zone: "9:00 Europe/Berlin"
LINE 1: insert into mytest values ('9:00 Europe/Berlin');
^
CREATE DATABASE
CREATE TABLE
INSERT 0 1
ERROR: invalid input syntax for type time with time zone: "9:00 Europe/Berlin"
LINE 1: insert into mytest values ('9:00 Europe/Berlin');
^
CREATE DATABASE
CREATE TABLE
INSERT 0 1
ERROR: invalid input syntax for type time with time zone: "9:00 Europe/Berlin"
LINE 1: insert into mytest values ('9:00 Europe/Berlin');
^
CREATE DATABASE
CREATE TABLE
INSERT 0 1
ERROR: invalid input syntax for type time with time zone: "9:00 Europe/Berlin"
LINE 1: insert into mytest values ('9:00 Europe/Berlin');
^
postgres(at)test:~$ dpkg -l | grep -e 'postgresql-1. '
ii postgresql-14 14.25-1.pgdg13+1 amd64 The
World's Most Advanced Open Source Relational Database
ii postgresql-15 15.20-1.pgdg13+1 amd64 The
World's Most Advanced Open Source Relational Database
ii postgresql-16 16.16-1.pgdg13+1 amd64 The
World's Most Advanced Open Source Relational Database
ii postgresql-17 17.12-1.pgdg13+1 amd64 The
World's Most Advanced Open Source Relational Database
ii postgresql-18 18.7-1.pgdg13+2 amd64 The
World's Most Advanced Open Source Relational Database
#### snap ####
Regards,
Uwe Sauter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-11-19 18:45:46 | Re: [PATCH] Fix encoding-dependent LIKE/regex selectivity estimates |
| Previous Message | Tomas Vondra | 2026-11-19 18:28:34 | Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed |