pgsql: Enable deduplication in system catalog indexes.

2021-10-02 Thread Peter Geoghegan
Enable deduplication in system catalog indexes. The "equality implies image equality" opclass infrastructure disallowed deduplication in system catalog indexes and TOAST indexes before now. That seemed like the right approach back when the infrastructure was added by commit 612a1ab7, since ALTER I

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: Update our mapping of Windows time zone names using CLDR info.

2021-10-02 Thread Tom Lane
Update our mapping of Windows time zone names using CLDR info. This corrects a bunch of entries in win32_tzmap[], and adds a few new ones, based on the CLDR project's windowsZones.xml file. Non-cosmetic changes fall into four main categories: * Flat-out errors: US/Aleutan doesn't exist America/S

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: Re-alphabetize the win32_tzmap[] array.

2021-10-02 Thread Tom Lane
Re-alphabetize the win32_tzmap[] array. The original intent seems to have been to sort case-insensitively by the Windows zone name, but various changes over the years did not get that memo. This commit just moves a few entries to restore exact alphabetic order, to ease comparison to the outputs o

pgsql: pg_stat_statements: Add some tests for older versions still usab

2021-10-02 Thread Michael Paquier
pg_stat_statements: Add some tests for older versions still usable When the newest version is loaded, the backend would load objects from the oldest complete SQL file (here 1.4) and then update to the latest version with transition scripts (up to 1.9 currently). This provides some coverage for up