Re: Converting non-null unique idx to pkey

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Kristo Kaiv <kristo(dot)kaiv(at)skype(dot)net>
Cc: Alban Hertroys <alban(at)magproductions(dot)nl>, "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Converting non-null unique idx to pkey
Date: 2007-08-23 13:10:31
Message-ID: 3720B7E9-9C98-4A24-A5D4-119E831E3936@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 23, 2007, at 7:44 , Kristo Kaiv wrote:

>
> On 23.08.2007, at 11:23, Alban Hertroys wrote:
>
>> Since you're setting up replication to another database, you might as
>> well try replicating to a newer release and swap them around once
>> it's
>> done. I've seen that method of upgrading mentioned on this list a
>> few times.
> Don't try this. Belive me you don't want to do it. We have had our
> fun with this 1.5 y ago

Care to share? Were you using Slony? AIUI, one of the motivations for
Slony was to be able to do exactly that, so I'm sure there's interest
in what didn't go as expected.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2007-08-23 13:35:14 Re: reporting tools
Previous Message Dmitry Koterov 2007-08-23 13:10:01 Re: How to switch off Snowball stemmer for tsearch2?