Re: BUG #6605: wrong type cast from timestamp to timestamptz

From: Jochen Erwied <jochen(at)pgsql-bugs(dot)erwied(dot)eu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6605: wrong type cast from timestamp to timestamptz
Date: 2012-04-23 05:20:26
Message-ID: 858616838.20120423072026@erwied.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Saturday, April 21, 2012, 7:49:55 PM you wrote:

> 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?

One machine works, the other not:

PostgreSQL 9.1.3 on i686-pc-linux-gnu, compiled by i686-pc-linux-gnu-gcc (Gentoo 4.5.3-r2 p1.0, pie-0.4.6) 4.5.3, 32-bit
Result: 2011-03-27 23:00:00+04

PostgreSQL 9.1.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (Gentoo 4.5.3-r2 p1.0, pie-0.4.6) 4.5.3, 64-bit
Result: 2011-03-28 00:29:40+04

--
Jochen Erwied | home: jochen(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message duncan.burke 2012-04-23 05:32:43 BUG #6608: SELECT FOR UPDATE not obtaining row exclusive locks in CTEs
Previous Message suvisor.root 2012-04-22 19:17:39 BUG #6607: Strange select behavior