Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-05 Thread Tom Lane
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.

[GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-05 Thread Scott Frankel
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 i

[GENERAL] Installation problem -- another installation is in progress

2008-07-05 Thread Susan Crayne
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

Re: [GENERAL] Target lists can have at most 1664 entries?

2008-07-05 Thread Bjørn T Johansen
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: > > > > W

Re: [GENERAL] AT TIME ZONE and DST in UTC<->CET conversion

2008-07-05 Thread Tom Lane
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

Re: [GENERAL] Target lists can have at most 1664 entries?

2008-07-05 Thread David Fetter
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

Re: [GENERAL] [Postgresql 8.2.3] autovacuum starting up even after disabling ?

2008-07-05 Thread Tom Lane
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

Re: [GENERAL] AT TIME ZONE and DST in UTC<->CET conversion

2008-07-05 Thread Gregory Stark
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

[GENERAL] AT TIME ZONE and DST in UTC<->CET conversion

2008-07-05 Thread Jaromír Talíř
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 TIME