Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group