From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
---|---|
To: | "Haifang Wang (Centific Technologies Inc)" <v-haiwang(at)microsoft(dot)com> |
Cc: | Rahul Pandey <pandeyrah(at)microsoft(dot)com>, Vishwa Deepak <Vishwa(dot)Deepak(at)microsoft(dot)com>, Shawn Steele <Shawn(dot)Steele(at)microsoft(dot)com>, Amy Wishnousky <amyw(at)microsoft(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Shweta Gulati <gulatishweta(at)microsoft(dot)com>, Ashish Nawal <nawalashish(at)microsoft(dot)com> |
Subject: | Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 |
Date: | 2024-07-21 11:54:37 |
Message-ID: | CA+hUKGJTOgnTzu4VD6Am0X6g67atkQHFVk+C-w5wkGrGiao-=Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
A minor release deadline is only a couple of weeks away and
unfortunately we still have no confirmation from a Windows user that
this technique can be used to unbreak a database cluster that actually
goes though that exact upgrade sequence. So I spent today figuring
out how to write a TAP test to try to convince myself of that in the
abstract. No C code change from v2. Does the test show a useful
enough pathway that is likely to help people in future cases at least?
I learned two new things:
1. With a remapped locale, you can log into your existing databases
again, but CREATE DATABASE doesn't work (see test). That must have
been the case for the historical transitions that were hard-coded
(Macau etc); this is no different, it's just that the mapping table is
now user-changeable. In other words, this just gives an administrator
a way to log into a cluster again after such a change, but then they
really need to update the names in catalogs, at least for any database
that might be used as a template, to get a 100% functional system. So
I have added a paragraph to the documentation piece to explain that.
2. Including the encoding suffix eg "en-US.1252" doesn't actually
work after all (discovered by CI). You have to use just "en-US". (I
guess ".UTF-8" must be a special case.) So I have updated the
documentation example.
Attachment | Content-Type | Size |
---|---|---|
v3-0001-Make-win32locale.c-s-kludge-table-dynamic.patch | text/x-patch | 26.2 KB |
v3-0002-ci-Enable-DEBUG_SETLOCALE_MAP-on-FreeBSD-task.patch | text/x-patch | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2024-07-21 13:28:15 | Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 |
Previous Message | PG Bug reporting form | 2024-07-20 22:12:30 | BUG #18547: bemused by your unhelpful installation guides |