Re: Make name optional in CREATE STATISTICS
Alvaro Herrera <alvherre@alvh.no-ip.org>
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Michael Paquier <michael@paquier.xyz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Dean Rasheed <dean.a.rasheed@gmail.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, Simon Riggs <simon.riggs@enterprisedb.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2022-07-25T10:55:54Z
Lists: pgsql-hackers
On 2022-Jul-25, Michael Paquier wrote:
> On Mon, Jul 25, 2022 at 11:49:50AM +0200, Alvaro Herrera wrote:
> > On 2022-Jul-23, Michael Paquier wrote:
> >> By the way, it seems that 83011ce also broke the case of "REINDEX
> >> DATABASE CONCURRENTLY", where the parser missed the addition of a
> >> DefElem for "concurrently" in this case.
> >
> > Wow.
>
> For this one, we have a gap in the test, actually. It seems to me
> that we'd better make sure that the OID of the indexes rebuilt
> concurrently is changed. There is a REINDEX DATABASE CONCURRENTLY
> already in the TAP tests, and the only thing that would be needed for
> the job is an extra query that compares the OID saved before the
> reindex with the one in the catalogs after the fact..
Agreed. I think you already have the query for that elsewhere in the
test, so it's just a matter of copying it from there.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"No tengo por qué estar de acuerdo con lo que pienso"
(Carlos Caszeli)
Commits
-
Fix a few issues with REINDEX grammar
- 0a5f06b84de7 16.0 landed
-
Rework grammar for REINDEX
- 83011ce7d7f4 16.0 landed
-
parser: centralize common auxiliary productions
- 7d158e8cb44b 16.0 landed
-
Make the name optional in CREATE STATISTICS.
- 624aa2a13bd0 16.0 landed