| From: | Koshino Taiki <koshino(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | "pgpool-hackers(at)lists(dot)postgresql(dot)org" <pgpool-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Feature: Import PostgreSQL 19 new parser. |
| Date: | 2026-08-20 08:44:44 |
| Message-ID: | OS9P286MB648625BA1C3AE2D8050044C094A42@OS9P286MB6486.JPNP286.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-hackers |
Hi,
I have updated the Pgpool-II parser to PostgreSQL 19.
Major parser changes in PostgreSQL 19 include:
- Add support for SQL Property Graph Queries (SQL/PGQ).
- Add FOR PORTION OF clauses to UPDATE and DELETE.
- Allow GROUP BY to process target-list subqueries containing
references to non-subquery columns.
- Allow window functions to use IGNORE NULLS and RESPECT NULLS.
- Add support for INSERT ... ON CONFLICT DO SELECT ... RETURNING.
- Add the REPACK command, which replaces VACUUM FULL and CLUSTER.
- Allow REPACK to rebuild tables without access-exclusive locking.
- Allow partitions to be merged and split using ALTER TABLE ...
MERGE/SPLIT PARTITIONS.
- Allow GRANT and REVOKE to specify the effective role.
- Allow CREATE SCHEMA to create more types of objects.
- Allow CHECKPOINT to accept a list of options.
- Add the CONNECTION clause to CREATE FOREIGN DATA WRAPPER.
- Add memory usage and parallelism reporting to VACUUM (VERBOSE).
etc.
Please review the attached patch.
Best regards,
Taiki Koshino<koshino(at)sraoss(dot)co(dot)jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/
| Attachment | Content-Type | Size |
|---|---|---|
| v8-0001-Feature-Import-PostgreSQL-19-new-parser.patch | application/octet-stream | 432.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-08-22 00:52:30 | Propose to change error code |
| Previous Message | Koshino Taiki | 2026-08-20 08:15:52 | [PATCH v1] Fix hang on deferred constraint errors in pipeline mode |