[pgpool-committers: 9503] pgpool: Feature: Import PostgreSQL 16 BETA1 new parser.

Chen Ningwei chen at sraoss.co.jp
Mon Jul 31 14:21:21 JST 2023


Feature: Import PostgreSQL 16 BETA1 new parser.

Major changes of PostgreSQL 16 parser include:

- Add new option DEFAULT to COPY FROM

  COPY ... FROM stdin WITH (default 'xx');

- Allow the STORAGE type to be specified by CREATE TABLE

  CREATE TABLE t1 (
     c1 VARCHAR(10) STORAGE PLAIN,
     c2 TEXT STORAGE EXTENDED
  );

- Add EXPLAIN option GENERIC_PLAN to display the generic plan for a parameterized query

  EXPLAIN (GENERIC_PLAN) SELECT ...;

- Allow subqueries in the FROM clause to omit aliases

  SELECT COUNT(*) FROM (SELECT ... FROM ...);

- Add SQL/JSON constructors

- Add VACUUM options
  SKIP_DATABASE_STATS, ONLY_DATABASE_STATS to skip or update all frozen statistics
  PROCESS_MAIN to only process TOAST tables

  VACUUM (SKIP_DATABASE_STATS);
  VACUUM (PROCESS_MAIN FALSE) t1 ;

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=ca300f8391f5963ff69248050b17393b6f93fab3

Modified Files
--------------
src/include/parser/keywords.h                      |    4 +-
src/include/parser/kwlist.h                        |   17 +-
src/include/parser/kwlist_d.h                      | 1045 ++++++++++----------
src/include/parser/makefuncs.h                     |   13 +-
src/include/parser/nodes.h                         |  610 ++----------
src/include/parser/nodetags.h                      |  471 +++++++++
src/include/parser/parsenodes.h                    |  531 +++++++---
src/include/parser/parser.h                        |    4 +-
src/include/parser/pg_class.h                      |    4 +-
src/include/parser/pg_config_manual.h              |   49 +-
src/include/parser/pg_list.h                       |   45 +-
src/include/parser/pg_trigger.h                    |    4 +-
src/include/parser/pg_wchar.h                      |   11 +-
src/include/parser/primnodes.h                     |  893 ++++++++++++-----
src/include/parser/scanner.h                       |    6 +-
src/include/parser/scansup.h                       |    4 +-
src/include/parser/stringinfo.h                    |    8 +-
src/include/parser/value.h                         |   16 +-
src/include/utils/pgstrcasecmp.h                   |    5 +
src/parser/copyfuncs.c                             |   18 +-
src/parser/gram.y                                  |  696 +++++++++----
src/parser/gram_minimal.y                          |  696 +++++++++----
src/parser/gram_template.y                         |  696 +++++++++----
src/parser/keywords.c                              |    4 +-
src/parser/kwlookup.c                              |    4 +-
src/parser/list.c                                  |   52 +-
src/parser/makefuncs.c                             |  104 +-
src/parser/nodes.c                                 |    4 +-
src/parser/outfuncs.c                              |   27 +-
src/parser/parser.c                                |   30 +-
src/parser/scan.l                                  |  107 +-
src/parser/scansup.c                               |    4 +-
src/parser/snprintf.c                              |   26 +-
src/parser/stringinfo.c                            |   12 +-
src/parser/value.c                                 |    4 +-
src/parser/wchar.c                                 |  634 ++++++------
.../tests/010.rewrite_timestamp/timestamp/Makefile |    2 +
src/utils/pgstrcasecmp.c                           |    7 +-
38 files changed, 4444 insertions(+), 2423 deletions(-)



More information about the pgpool-committers mailing list