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
|
| Список | pgsql-general |
* 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 по дате отправления: