Re: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone.
Дата
Msg-id 21109.1588255724@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16404: PostgreSQL 12.2: Database restore does not accept the EEST time zone.  (PG Bug reporting form <noreply@postgresql.org>)
Ответы VS: BUG #16404: PostgreSQL 12.2: Database restore does not accept theEEST time zone.  ("Suhonen Reijo (Valtori)" <reijo.suhonen@valtori.fi>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Database restore does not accept the EEST time zone. PostgreSQL version 10
> restore accept EEST timezone.

Works for me:

# select '2020-04-30 10:01:32.277852 EEST'::timestamptz;
          timestamptz          
-------------------------------
 2020-04-30 03:01:32.277852-04
(1 row)

Maybe you are using a non-default timezone_abbreviations file? [1]

In any case, it's not very clear why this would be a database
restore issue.  Dump/restore should always use numeric UTC
offsets in dumped timestamps.

Anyway, you'll need to provide a lot more detail if you want
help on this.

            regards, tom lane

[1] https://www.postgresql.org/docs/current/datetime-config-files.html



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16403: set_bit function does not have expected effect
Следующее
От: "断桥烟雨三两月"
Дата:
Сообщение: 回复: report bug