BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, Patch count: 1, First patch: +133−5, All patches: +133−5

Tags

Bugfix

Created

2026-10-27 05:32:27

Last modified

2026-10-27 05:33:07 (4 hours ago)

Latest email

2026-10-27 06:51:44 (3 hours ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

Authors

Narayanan Venkateswaran (narayananv)

Reviewers

Become reviewer

Committer

Links

Emails

BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses: First at 2026-10-02 22:36:20 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-10-27 06:51:44 by Narayanan Venkateswaran <narayananvpostgres at gmail.com>
Latest attachment (v3-0001-Allow-NULL-and-UNIQUE-clauses-in-empty-JSON_OBJEC.patch) at 2026-10-27 06:51:44 from Narayanan Venkateswaran <narayananvpostgres at gmail.com>
    Attachment (v3-0001-Allow-NULL-and-UNIQUE-clauses-in-empty-JSON_OBJEC.patch) at 2026-10-27 06:51:44 from Narayanan Venkateswaran <narayananvpostgres at gmail.com> (Patch: No)
    Attachment (v2-0001-Allow-NULL-and-UNIQUE-clauses-in-empty-JSON_OBJEC.patch) at 2026-10-19 20:23:54 from Narayanan Venkateswaran <narayananvpostgres at gmail.com> (Patch: No)
    Attachment (v1-0001-Allow-NULL-and-UNIQUE-clauses-in-empty-JSON_OBJEC.patch) at 2026-10-14 13:35:50 from Narayanan Venkateswaran <narayananvpostgres at gmail.com> (Patch: No)
    Attachment (draft_json_object_fix.txt) at 2026-10-04 16:14:55 from jian he <jian.universality at gmail.com> (Patch: Yes)

History

When	Who	What
2026-10-27 05:33:07	Narayanan Venkateswaran (narayananv)	Changed name to BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses
2026-10-27 05:32:27	Narayanan Venkateswaran (narayananv)	Attached mail thread 19737-b44cf2e08708b613@postgresql.org
2026-10-27 05:32:27	Narayanan Venkateswaran (narayananv)	Created patch record