Bruce Momjian 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.
You shouldn't insert encodings in the middle, because those numbers are exposed to clients. We've had troubles with that before. If you add an encoding, append it as the last one (before the client encodings in this case). This would probably also eliminate the need for the initdb. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
