Re: WIN1252 patch broke my database

Mark Woodward wrote:
> > Tom Lane wrote:
> >> You can't just randomly rearrange the pg_enc enum without forcing an
> >> initdb, because the numeric values of the encodings appear in system
> >> catalogs (eg pg_conversion).
> >
> > Oh, those numbers appear in the catalogs?  I didn't relealize that.
> >
> > I will force an initdb.
> >
> Doesn't that also force the end-user to initdb with an upgrade?

Yes, 8.1 will require a dump/reload for upgrade.  I think we decided
that was going to be necessary.

That has aleady happened for 8.1:
date: 2005/02/28 03:45:21;  author: neilc;  state: Exp;  lines: +2 -2Implement max() and min() aggregates for array
types.Patch from KojuIijima, reviewed by Neil Conway. Catalog version number bumped,regression tests updated.
 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073