Jorge Campins wrote:
Dear All,
I installed 8.2.6.2 and solved my problem. I set Windows time zone to
"Caracas" and PostgreSQL "America/Caracas" and now they both give me the
right time.
WARNING: not only people in Venezuela but also people in Bolivia is
affected by this problem. As you migh
ot;Alvaro Herrera" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Jorge Campins" <[EMAIL PROTECTED]>;
Sent: Monday, February 11, 2008 4:05 AM
Subject: Re: [BUGS] BUG #3948: date/time functions returning wrong value
On Sun, Feb 10, 2008 a
On Sun, Feb 10, 2008 at 11:22:53PM -0300, Alvaro Herrera wrote:
> Magnus Hagander wrote:
> > Tom Lane wrote:
>
> >> This does suggest that we'll need to revisit the win32_tzmap[] list
> >> every so often?
> >
> > Seems so. It's the first time I've heard of a timezone being *added* and
> > not ju
On Sun, Feb 10, 2008 at 09:33:46PM -0500, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > I think what I conclude from this is that Windows TZ database is so
> > bogus that we should avoid trying to rely on it -- I say if the user
> > does not set "timezone" in postgresql.conf, ref
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I think what I conclude from this is that Windows TZ database is so
> bogus that we should avoid trying to rely on it -- I say if the user
> does not set "timezone" in postgresql.conf, refuse to start.
Remember we're also relying on the OS for the time
Magnus Hagander wrote:
> Tom Lane wrote:
>> This does suggest that we'll need to revisit the win32_tzmap[] list
>> every so often?
>
> Seems so. It's the first time I've heard of a timezone being *added* and
> not just changed, but obviously it does happen :-(
Hmm, was this table manually built
m Lane" <[EMAIL PROTECTED]>;
Sent: Sunday, February 10, 2008 5:39 AM
Subject: Re: [BUGS] BUG #3948: date/time functions returning wrong value
Jorge Campins wrote:
How can I find which version I'm using? All I could see in pgAdmin is
8.1.
SELECT version();
Which value should I
sage - From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "Jorge Campins" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Sunday, February 10, 2008 5:39 AM
Subject: Re: [BUGS] BUG #3948: date/time functions returning wrong value
Jorg
Tom Lane wrote:
Magnus Hagander <[EMAIL PROTECTED]> writes:
Try setting your timezone in postgresql.conf - that should override
whatever Windows has for you.
Unless his "8.1" is really 8.1.something-pretty-darn-recent, it's
not going to know about the latest Venezuela DST law change anyway.
Jorge Campins wrote:
How can I find which version I'm using? All I could see in pgAdmin is 8.1.
SELECT version();
Which value should I use for timezone in postgresql.conf? I tried select
* from pg_timezone_names to get a list of valid time zone names but it
failed with "relation pg_timezon
t;
Thanks and regards,
Jorge
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Magnus Hagander" <[EMAIL PROTECTED]>
Cc: "Jorge Campins" <[EMAIL PROTECTED]>;
Sent: Saturday, February 09, 2008 8:25 PM
Subject: Re: [BUGS] BUG #394
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Try setting your timezone in postgresql.conf - that should override
> whatever Windows has for you.
Unless his "8.1" is really 8.1.something-pretty-darn-recent, it's
not going to know about the latest Venezuela DST law change anyway.
This does sugges
Jorge Campins wrote:
The following bug has been logged online:
Bug reference: 3948
Logged by: Jorge Campins
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP
Description:date/time functions returning wrong value
Details:
As you
The following bug has been logged online:
Bug reference: 3948
Logged by: Jorge Campins
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP
Description:date/time functions returning wrong value
Details:
As you might be aware, recentl
14 matches
Mail list logo
