pgsql: Prefer timezone name "UTC" over alternative spellings.

2019-06-15 Thread Andrew Gierth
Prefer timezone name "UTC" over alternative spellings. tzdb 2019a made "UCT" a link to the "UTC" zone rather than a separate zone with its own abbreviation. Unfortunately, our code for choosing a timezone in initdb has an arbitrary preference for names earlier in the alphabet, and so it would choo

pgsql: Prefer timezone name "UTC" over alternative spellings.

2019-06-15 Thread Andrew Gierth
Prefer timezone name "UTC" over alternative spellings. tzdb 2019a made "UCT" a link to the "UTC" zone rather than a separate zone with its own abbreviation. Unfortunately, our code for choosing a timezone in initdb has an arbitrary preference for names earlier in the alphabet, and so it would choo

pgsql: Prefer timezone name "UTC" over alternative spellings.

2019-06-15 Thread Andrew Gierth
Prefer timezone name "UTC" over alternative spellings. tzdb 2019a made "UCT" a link to the "UTC" zone rather than a separate zone with its own abbreviation. Unfortunately, our code for choosing a timezone in initdb has an arbitrary preference for names earlier in the alphabet, and so it would choo

pgsql: Prefer timezone name "UTC" over alternative spellings.

2019-06-15 Thread Andrew Gierth
Prefer timezone name "UTC" over alternative spellings. tzdb 2019a made "UCT" a link to the "UTC" zone rather than a separate zone with its own abbreviation. Unfortunately, our code for choosing a timezone in initdb has an arbitrary preference for names earlier in the alphabet, and so it would choo

pgsql: Prefer timezone name "UTC" over alternative spellings.

2019-06-15 Thread Andrew Gierth
Prefer timezone name "UTC" over alternative spellings. tzdb 2019a made "UCT" a link to the "UTC" zone rather than a separate zone with its own abbreviation. Unfortunately, our code for choosing a timezone in initdb has an arbitrary preference for names earlier in the alphabet, and so it would choo

pgsql: Prefer timezone name "UTC" over alternative spellings.

2019-06-15 Thread Andrew Gierth
Prefer timezone name "UTC" over alternative spellings. tzdb 2019a made "UCT" a link to the "UTC" zone rather than a separate zone with its own abbreviation. Unfortunately, our code for choosing a timezone in initdb has an arbitrary preference for names earlier in the alphabet, and so it would choo

pgsql: Fix incorrect CREATE STATISTICS example in docs

2019-06-15 Thread Tomas Vondra
Fix incorrect CREATE STATISTICS example in docs The example was incorrectly using parantheses around the list of columns, so just drop them. Reported-By: Robert Haas Discussion: https://postgr.es/m/CA%2BTgmoZZEMAqWMAfvLHZnK57SoxOutgvE-ALO94WsRA7zZ7wyQ%40mail.gmail.com Branch -- master Deta

pgsql: Add pg_stats_ext view for extended statistics

2019-06-15 Thread Tomas Vondra
Add pg_stats_ext view for extended statistics Regular per-column statistics are stored in pg_statistics catalog, which is however rather difficult to read, so we also have pg_stats view with a human-reablable version of the data. For extended statistic the catalog was fairly easy to read, so we d

pgsql: Rework the pg_statistic_ext catalog

2019-06-15 Thread Tomas Vondra
Rework the pg_statistic_ext catalog Since extended statistic got introduced in PostgreSQL 10, there was a single catalog pg_statistic_ext storing both the definitions and built statistic. That's however problematic when a user is supposed to have access only to the definitions, but not to user da

Re: pgsql: Rework the pg_statistic_ext catalog

2019-06-15 Thread Tom Lane
Tomas Vondra writes: > Rework the pg_statistic_ext catalog So ... not one of the buildfarm members that are running TAP tests likes this. The failures look like # Running: pg_dump --no-sync --file=/Users/tgl/pgsql/src/bin/pg_dump/tmp_check/tmp_test_cSh8/role.sql --role=regress_dump_test_role

Re: pgsql: Rework the pg_statistic_ext catalog

2019-06-15 Thread Tom Lane
I wrote: > Tomas Vondra writes: >> Rework the pg_statistic_ext catalog > So ... not one of the buildfarm members that are running TAP tests > likes this. ... > I think probably what's happening is that pg_dump is still trying to dump > directly from the catalog, when what it needs to do now is du

Re: pgsql: Rework the pg_statistic_ext catalog

2019-06-15 Thread Dean Rasheed
On Sun, 16 Jun 2019, 03:05 Tom Lane, wrote: > I wrote: > > Tomas Vondra writes: > >> Rework the pg_statistic_ext catalog > > > So ... not one of the buildfarm members that are running TAP tests > > likes this. ... > > I think probably what's happening is that pg_dump is still trying to dump > >