eshkin...@gmail.com writes: > set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz; > SET > timestamptz > ------------------------ > 2011-03-28 02:59:54+04
Bizarre. On my Fedora 16 box, I see a different misbehavior: regression=# set timezone to 'Europe/Moscow'; select '2011-03-27 23:00:00'::timestamptz; SET timestamptz ------------------------ 2011-03-28 00:29:40+04 (1 row) (W-SU behaves the same, incidentally.) Two other machines are fine with this case, though. It may or may not be relevant that the F16 build is using --with-system-tzdata, as I imagine your Debian package is also, while the machines that are happy are not. So: some platform-specific misbehavior here. I have no time to poke at it more now, though. Who else can reproduce this, on what platforms? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs