Re: How to remove non-UTF values from a table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rod(at)iol(dot)ie
Cc: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>, Howard Cole <howardnews(at)selestial(dot)com>, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to remove non-UTF values from a table?
Date: 2009-12-16 16:55:22
Message-ID: 5593.1260982522@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Raymond O'Donnell" <rod(at)iol(dot)ie> writes:
> On 16/12/2009 15:01, Richard Broersma wrote:
>> It looks like the future 8.5 release will be able to
>> preform an in-place upgrade on 8.4.

> Really? That would be *wonderful*. I know it's impossible to be
> definitive, but how likely would you say this is?

It's wishful thinking. We tried to have that for 8.4, and failed: there
are so many constraints on pg_upgrade that it's not a usable mainstream
solution. So far as I've seen there has been no work done that would
make it any more reliable for 8.5.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-12-16 17:39:04 Re: Slow select
Previous Message Greg Smith 2009-12-16 16:25:11 Re: Possible causes for database corruption and solutions