Horton

Make the name optional in CREATE STATISTICS.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 624aa2a13bd02dd584bb0995c883b5b93b2152df
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2022-07-21T18:23:13Z
Releases: 16.0 
Make the name optional in CREATE STATISTICS.

This allows users to omit the statistics name in a CREATE STATISTICS
command, letting the system auto-generate a sensible, unique name,
putting the statistics object in the same schema as the table.

Simon Riggs, reviewed by Matthias van de Meent.

Discussion: https://postgr.es/m/CANbhV-FGD2d_C3zFTfT2aRfX_TaPSgOeKES58RLZx5XzQp5NhA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ref/create_statistics.sgml modified +8 −4
src/backend/commands/statscmds.c modified +3 −4
src/backend/parser/gram.y modified +10 −3
src/test/regress/expected/stats_ext.out modified +51 −36
src/test/regress/sql/stats_ext.sql modified +14 −6

Documentation touched

Discussion