Re: Pg subtracts one minute from time

From: Barry Stewart <bstewart(at)smyrnacable(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: bstewart(at)smyrnacable(dot)net, pgsql-novice(at)postgresql(dot)org
Subject: Re: Pg subtracts one minute from time
Date: 2001-01-12 17:45:30
Message-ID: 20010112124530.C6652@genesis.kingdom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

echo $TZ and echo $PGTZ both came up empty. So I exported both as
"EST5EDT" (as root) and restarted postgresql, but still no luck.

Thanks for your prompt attention. I'm going to give more info to Thomas,
but if you have any more suggestions, let me know.

Thanks for your prompt attention,

Barry

On 2001.01.12 11:50:20 -0500 Tom Lane wrote:
> Barry Stewart <bstewart(at)smyrnacable(dot)net> writes:
> > I'm using Trustix Secure Linux 1.2 (RedHat based) on a Pentium 200MMX
> and
> > Postgresql 7.02.
>
> Seems like a fairly vanilla-flavored platform... I'm baffled, to tell
> you the truth. I sent a heads-up to our date/time maven, Thomas
> Lockhart, who might have an idea what's going wrong here.
>
> > How do I check the TZ/PGTZ variables? On the command
> > line, the date command says:
> > Fri Jan 12 11:37:36 EST 2001
>
> Try "echo $TZ" at the command line. Given that date output, I'm
> guessing that you'll see "EST5EDT". Just for grins, you might try
>
> export PGTZ="EST5EDT"
>
> before starting psql, and then see if the behavior is the same or not.
> Probably won't help but it'd be worth making sure.
>
> regards, tom lane
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ken Corey 2001-01-12 18:08:49 Syntax highlighting for plpgsql (in VIM, even)?
Previous Message Tom Lane 2001-01-12 16:50:20 Re: Pg subtracts one minute from time