Re: Row pattern recognition

Tatsuo Ishii <ishii@sraoss.co.jp>

From: Tatsuo Ishii <ishii@sraoss.co.jp>

To: jacob.champion@enterprisedb.com, vik@postgresfriends.org

Cc: pgsql-hackers@postgresql.org, er@xs4all.nl, peter@eisentraut.org

Date: 2024-05-15T00:02:03Z

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

v19-0001-Row-pattern-recognition-patch-for-raw-parser.patch (text/x-patch)

Attached are the v19 patches. Changes from v18 include:

0002:
- add a check whether DEFINE clause includes subqueries. If so, error out.
0007:
- fix wrong test (row pattern definition variable name must not appear
  more than once)
- remove unnessary test (undefined define variable is not allowed).
  We have already allowed the undefined variables.
- add tests: subqueries and aggregates in DEFINE clause are not
  supported. The standard allows them but I have not implemented them
  yet.

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