Re: Row pattern recognition

Tatsuo Ishii <ishii@postgresql.org>

From: Tatsuo Ishii <ishii@postgresql.org>

To: david.g.johnston@gmail.com, vik@postgresfriends.org, jacob.champion@enterprisedb.com, er@xs4all.nl, peter@eisentraut.org

Cc: pgsql-hackers@postgresql.org

Date: 2025-03-13T12:51:29Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add temporal FOREIGN KEY contraints
- 89f908a6d0ac 18.0 cited
Remove obsolete executor cleanup code
- d060e921ea5a 17.0 cited

Attachments

v29-0001-Row-pattern-recognition-patch-for-raw-parser.patch (application/octet-stream) patch v29-0001
v29-0002-Row-pattern-recognition-patch-parse-analysis.patch (application/octet-stream) patch v29-0002
v29-0003-Row-pattern-recognition-patch-rewriter.patch (application/octet-stream) patch v29-0003
v29-0004-Row-pattern-recognition-patch-planner.patch (application/octet-stream) patch v29-0004
v29-0005-Row-pattern-recognition-patch-executor.patch (application/octet-stream) patch v29-0005
v29-0006-Row-pattern-recognition-patch-docs.patch (application/octet-stream) patch v29-0006
v29-0007-Row-pattern-recognition-patch-tests.patch (application/octet-stream) patch v29-0007
v29-0008-Row-pattern-recognition-patch-typedefs.list.patch (application/octet-stream) patch v29-0008
v29-0009-Allow-to-print-raw-parse-tree.patch (application/octet-stream) patch v29-0009

Attached are the v29 patch sets to implement the subset of row pattern
recognition feature defined in the SQL standard.

In this patch set:

- Adjust 0003 and 0004 to deal with the recent changes made by 8b1b342.
 
- Add tests to 0007 for CREATE VIEW/pg_get_viewdef.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp