Thread: BUG #8067: now() bug?

The following bug has been logged on the website:

Bug reference:      8067
Logged by:          Istvan Kassai
Email address:      kako@zhnet.hu
PostgreSQL version: 9.0.1
Operating system:   Linux DRONE 2.6.32.27 #5 Wed Dec 21 12:11:46 CET 2
Description:        =


function "now()" sometimes returns with a value with timezone data,
sometimes without.

for example:

*****************************************
therm=3D# select now();
            now
----------------------------
 2013-04-14 06:58:12.056065
(1 row)

therm=3D# select now();
              now
-------------------------------
 2013-04-14 08:58:12.766165+02
(1 row)

therm=3D# select now();
            now
----------------------------
 2013-04-14 06:58:16.046629
(1 row)
*****************************************

is it a bug or a feature?

kako@zhnet.hu writes:
> function "now()" sometimes returns with a value with timezone data,
> sometimes without.

[ raised eyebrow... ]  Not for me, and not for anyone else that I've
ever heard of.  You've got a seriously broken build, I'm thinking.
Where did you get the PG executables from, or if you built them
yourself, what compiler and compile options did you use?

BTW, 9.0.1 is quite old --- that release series is at 9.0.13.

            regards, tom lane