First, if I do conversion from UTC to CET and back when a timestamp is
OUTSIDE of daylight saving period, it's correct:
postgres# select '2008-01-01 10:10:10 UTC' AT TIME ZONE 'CET';
timezone
-
2008-01-01 11:10:10
postgres# select '2008-01-01 11:10:10 CET' AT
Jaromír Talíř [EMAIL PROTECTED] writes:
postgres# select '2008-06-01 10:10:10 UTC' AT TIME ZONE 'CET';
timezone
-
2008-06-01 12:10:10
ISTM this is the one that's wrong. CET is standard time, it, GMT+1.
If you want a timezone which switches between CET and
dushy [EMAIL PROTECTED] writes:
On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver [EMAIL PROTECTED] wrote:
One question? Did you do pg_ctl reload after changing the config file?
I did not change any config yet - autovacuum was always disabled since
the day PG was set up.
A mistake here seems by
On Wed, Jul 02, 2008 at 09:22:50AM +0200, Bjørn T Johansen wrote:
On Wed, 02 Jul 2008 03:04:04 -0400
Tom Lane [EMAIL PROTECTED] wrote:
=?UTF-8?Q?Bj=C3=B8rn?= T Johansen [EMAIL PROTECTED] writes:
What does this mean and how can it be fixed?
Reduce the number of columns in your SELECTs?
Gregory Stark [EMAIL PROTECTED] writes:
ISTM this is the one that's wrong. CET is standard time, it, GMT+1.
If you want a timezone which switches between CET and CST automatically you
should use something like Europe/Paris.
Well, actually he *is* using such a zone:
regression=# select * from
On Sat, 5 Jul 2008 08:17:37 -0700
David Fetter [EMAIL PROTECTED] wrote:
On Wed, Jul 02, 2008 at 09:22:50AM +0200, Bjørn T Johansen wrote:
On Wed, 02 Jul 2008 03:04:04 -0400
Tom Lane [EMAIL PROTECTED] wrote:
=?UTF-8?Q?Bj=C3=B8rn?= T Johansen [EMAIL PROTECTED] writes:
What does this
I am attempting to install the postrgresql-8.3.3-1 download on Windows Vista.
When I get to the Ready to install dialog and click OK, I get the message
Another installation is in progress, and I need to click on cancel and end
the installation -- otherwise I am in a loop. This happens even
Hello, I just signed on the list.
Any suggestions for how best to launch one of two different versions
of pg installed on the same machine?
I have both 8.3 and 8.1 installed on a MacBookPro (OS X 10.5.2). I
stopped the 8.3 postmaster using pg_ctl in order to roll back to 8.1.
Problem
Scott Frankel [EMAIL PROTECTED] writes:
Any suggestions for how best to launch one of two different versions
of pg installed on the same machine?
I have both 8.3 and 8.1 installed on a MacBookPro (OS X 10.5.2). I
stopped the 8.3 postmaster using pg_ctl in order to roll back to 8.1.