Re: [GENERAL] recovery dump on database with different timezone

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] recovery dump on database with different timezone
Дата
Msg-id CAKFQuwaU_WsRWpnp7kShK8P9kNctw1=Lnch7j0zOBUOA3282VA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] recovery dump on database with different timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] recovery dump on database with different timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

        * this the  constraint:  "time_stamp_201012ad" CHECK (time_stamp >=
        '2010-12-01'::date AND time_stamp < '2011-01-01'::date)

        if change 2011-01-01 00:00:03.925+00 to 2011-01-01
        00:00:03.925-06  works ok

Not seeing how?:

production=# show timezone;
 TimeZone
----------
 UTC
(1 row)


production=# select ' 2011-01-01 00:00:03.925+00'::timestamptz  < '2011-01-01'::date;
 ?column?
----------
 f
(1 row)

production=# select ' 2011-01-01 00:00:03.925+00'::timestamptz  < '2011-01-01'::date;
 ?column?
----------
 f
(1 row)

​You failed to change the timezone to -06 in the second query...

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] recovery dump on database with different timezone
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] recovery dump on database with different timezone