SQL Property Graph Queries (SQL/PGQ)

Edit
ID 4904
Title SQL Property Graph Queries (SQL/PGQ)
CI (CFBot) Summary
Stats (from CFBot) Patch version: v20260225, Patch count: 2, First patch: +14829−211, All patches: +14830−213
Tags SQL Commands
Created 2024-03-22 13:00:05
Last modified 2026-02-01 00:00:09 (3 weeks ago)
Latest email 2026-02-25 11:33:58 (8 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
Target version
Authors Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat)
Reviewers Vik Fearing (xocolatl), Zhao Junwang (zhjwpku), Hannu Krosing (hannukrosing), Henson Choi (assam258.gmail.com)Become reviewer
Committer
Links
Emails
SQL Property Graph Queries (SQL/PGQ)
First at 2024-02-16 14:53:11 by Peter Eisentraut <peter at eisentraut.org>
Latest at 2026-02-25 11:33:58 by Peter Eisentraut <peter at eisentraut.org>
Latest attachment (nocfbot-0001-Add-BEGIN_CATALOG_STRUCT-END_CATALOG_STRUCT.patch) at 2026-02-25 11:33:58 from Peter Eisentraut <peter at eisentraut.org>
    Attachment (nocfbot-0001-Add-BEGIN_CATALOG_STRUCT-END_CATALOG_STRUCT.patch) at 2026-02-25 11:33:58 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260225-0002-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-25 08:28:21 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260225-0002-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-25 06:40:55 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Sort-out-RELKIND_PROPGRAPH-table_open-v2.patch) at 2026-02-19 09:31:22 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-18 15:28:02 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260113-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2026-01-13 16:14:22 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Various-small-updates.patch.nocfbot) at 2026-01-13 10:23:25 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260109-0003-SQL-PGQ-Support-multi-pattern-path-matching-in-GRAPH.txt) at 2026-01-09 06:53:29 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20260102-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2026-01-02 08:48:03 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (valgrind.tgz) at 2026-01-01 06:16:00 from Henson Choi <assam258 at gmail.com> (Patch: No)
    Attachment (coverage.tgz) at 2025-12-31 06:23:13 from Henson Choi <assam258 at gmail.com> (Patch: No)
    Attachment (v20251230-2-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-30 11:27:15 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v20251230-0002-Fix-some-more-references-and-edit-document.patch) at 2025-12-30 09:44:02 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20251226-0002-SQL-PGQ-Add-PROPERTY_NAMES-graph-element-function.patch) at 2025-12-26 12:33:41 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20251225-0001-Add-LABELS-graph-element-function.patch) at 2025-12-24 16:23:11 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20251218-0002-create_property_graph-test-changes.patch) at 2025-12-18 09:15:29 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Add-test-for-properties-typmod-mismatch.patch.nocfbot) at 2025-12-17 08:58:22 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20251217-0002-Edge-in-any-direction-bug.patch) at 2025-12-17 05:32:30 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20251215-0002-Edge-in-any-direction-bug.patch) at 2025-12-15 13:13:08 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (test2.sql) at 2025-12-13 19:57:56 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
    Attachment (v20251209-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-09 10:21:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v-20251202-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-02 10:00:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Typos-and-minor-style-fixes.patch.nocfbot) at 2025-11-25 13:52:21 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (order_keyword_fix.diff.txt) at 2025-11-24 05:00:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (SQL_PGQ_20251120.zip) at 2025-11-20 15:13:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (sql_pgq_one_patch_20250807.zip) at 2025-08-07 10:47:37 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (SQL_PGQ_20250722.zip) at 2025-07-22 11:40:26 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (pg-sql-pgq-20250311-nodups.tar.gz) at 2025-07-06 16:10:47 from Hannu Krosing <hannuk at google.com> (Patch: No)
    Attachment (pg-sql-pgq-20250311.zip) at 2025-03-11 07:21:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v14-0011-handle-RTE_GRAPH_TABLE-in-AcquireRewriteLocks.patch) at 2025-03-11 06:06:41 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v12-0010-adapt-property-graph-to-more-intuitive-titles.patch) at 2025-02-26 14:34:38 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v11-0013-refactor-insert_property_record-and-reduce-call-.patch) at 2025-02-23 12:54:53 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v10-0011-do-not-use-default-COLLATE.patch) at 2025-02-10 15:00:05 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (0001-trivial-refactor-of-property-graph-object-address.txt) at 2025-02-06 14:52:32 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (pg_sql_pgq-20250128.zip) at 2025-01-28 10:26:45 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0002-trivial-refactor.patch) at 2025-01-24 15:46:30 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (sql_pgq_patch_set_20250124.zip) at 2025-01-24 13:36:11 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (sql-pgq-2025-01-01.zip) at 2025-01-01 09:01:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0002-support-WHERE-clause-in-graph-pattern-20250101.patch) at 2025-01-01 08:52:29 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Broken-out-tokeniziation-of-arrows.patch) at 2024-12-21 21:45:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v1-0001-fix-wrong-ref-keys.txt) at 2024-12-21 12:51:04 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (0004-Fixes-following-issues-20241205.patch) at 2024-12-05 11:42:11 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-support-WHERE-clause-in-graph-pattern-20241122.patch) at 2024-11-22 13:59:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0004-Fixes-following-issues-20241105.patch) at 2024-11-05 15:41:24 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Broken-out-tokeniziation-of-arrows.patch) at 2024-10-29 19:55:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (0004-Fix-spurious-column-not-found-error-20240828.patch) at 2024-08-28 10:18:46 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (testcase.sql) at 2024-08-13 10:38:07 from Ajay Pal <ajay.pal.k at gmail.com> (Patch: No)
    Attachment (testcase.sql) at 2024-08-13 09:52:43 from Ajay Pal <ajay.pal.k at gmail.com> (Patch: No)
    Attachment (0003-Fix-compilation-error-20240805.patch) at 2024-08-10 09:21:43 from Imran Zaheer <imran.zhir at gmail.com> (Patch: Yes)
    Attachment (0004-Fix-spurious-column-not-found-error-20240805.patch) at 2024-08-05 12:41:20 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0006-Support-for-EXCEPT-list-in-Labels-and-properties.patch) at 2024-08-04 07:02:07 from Imran Zaheer <imran.zhir at gmail.com> (Patch: Yes)
    Attachment (0002-pgperltidy-fixes-20240722.patch) at 2024-07-22 12:01:42 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0003-Fix-compilation-error-20240717.patch) at 2024-07-17 05:34:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Fix-compilation-error-20240708.patch) at 2024-07-08 13:37:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2024-06-27 12:31:00 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
    Attachment (0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ-20240305.patch) at 2024-03-05 12:08:30 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v0-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2024-02-16 14:53:11 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
History
When Who What
2026-02-25 07:08:32 CFbot Patch does not need rebase anymore
2026-02-11 23:13:27 CFbot Patch needs rebase
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-01 06:36:27 CFbot Patch does not need rebase anymore
2025-12-31 06:31:25 CFbot Patch needs rebase
2025-12-30 10:10:28 CFbot Patch does not need rebase anymore
2025-12-26 02:57:15 Henson Choi (assam258.gmail.com) Added assam258.gmail.com as reviewer
2025-12-24 16:38:22 CFbot Patch needs rebase
2025-12-15 13:33:28 CFbot Patch does not need rebase anymore
2025-12-15 07:57:24 CFbot Patch needs rebase
2025-12-11 17:04:59 Hannu Krosing (hannukrosing) Added hannukrosing as reviewer
2025-12-03 10:52:27 Peter Eisentraut (petere) Moved from CF PG19-3 to CF PG19-4
2025-12-03 10:52:21 Peter Eisentraut (petere) New status: Needs review
2025-11-20 15:44:31 CFbot Patch does not need rebase anymore
2025-10-20 11:24:55 Peter Eisentraut (petere) Moved from CF PG19-2 to CF PG19-3
2025-09-05 12:41:23 CFbot Patch needs rebase
2025-09-01 10:49:25 CFbot Patch does not need rebase anymore
2025-08-12 06:49:52 Peter Eisentraut (petere) Moved from CF PG19-1 to CF PG19-2
2025-08-06 12:42:26 CFbot Patch needs rebase
2025-06-15 20:07:39 CFbot Patch does not need rebase anymore
2025-04-06 12:24:56 Peter Eisentraut (petere) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-23 22:47:40 CFbot Patch needs rebase
2025-03-11 07:31:45 CFbot Patch does not need rebase anymore
2025-03-11 04:15:28 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-10 23:33:40 CFbot Patch needs rebase
2025-02-24 14:34:45 CFbot Patch does not need rebase anymore
2025-02-22 10:33:41 CFbot Patch needs rebase
2025-02-04 07:53:08 Ashutosh Bapat (ashutoshbapat) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-22 05:41:12 Zhao Junwang (zhjwpku) Added zhjwpku as reviewer
2024-12-01 14:24:09 Peter Eisentraut (petere) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-25 10:52:23 Vik Fearing (xocolatl) Added xocolatl as reviewer
2024-09-30 19:18:22 Peter Eisentraut (petere) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 05:54:56 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-27 12:31:47 Peter Eisentraut (petere) Changed authors to Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat)
2024-03-22 13:00:19 Peter Eisentraut (petere) Changed authors to Peter Eisentraut (petere)
2024-03-22 13:00:05 Peter Eisentraut (petere) Attached mail thread a855795d-e697-4fa5-8698-d20122126567@eisentraut.org
2024-03-22 13:00:05 Peter Eisentraut (petere) Created patch record
Edit