From: | "Anton A(dot) Melnikov" <a(dot)melnikov(at)postgrespro(dot)ru> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Should timezone be inherited from template database? |
Date: | 2023-11-26 14:47:49 |
Message-ID: | e92a3992-4ed7-48c4-8262-81bdf8b957de@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello!
Found that if i set a specific time zone for a template database,
it will not be inherited in the database created from that template.
psql (17devel)
Type "help" for help.
postgres=# select now();
now
-------------------------------
2023-11-26 17:24:58.242086+03
(1 row)
postgres=# ALTER DATABASE template1 SET TimeZone = 'UTC';
ALTER DATABASE
postgres=# \c template1
You are now connected to database "template1" as user "postgres".
template1=# select now();
now
-------------------------------
2023-11-26 14:26:09.291082+00
(1 row)
template1=# CREATE DATABASE test;
CREATE DATABASE
template1=# \c test
You are now connected to database "test" as user "postgres".
test=# select now();
now
-------------------------------
2023-11-26 17:29:05.487984+03
(1 row)
Could you clarify please. Is this normal, predictable behavior?
Would be very grateful!
--
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Kirtika Gautam | 2023-11-26 15:14:35 | How to get started with contributions |
Previous Message | Bruce Momjian | 2023-11-26 14:27:34 | Re: Missing docs on AT TIME ZONE precedence? |