| From: | Narayanan Venkateswaran <narayananvpostgres(at)gmail(dot)com> |
|---|---|
| To: | Nitin Motiani <nitinmotiani(at)google(dot)com> |
| Cc: | theshallow27(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org, Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
| Subject: | Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses |
| Date: | 2026-10-19 20:23:54 |
| Message-ID: | CAFjuD9fhbn8AGqUfcDqeEL+d1cSe-9q4K9rNOAeqv=MzmZK_+A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
On Tue, Oct 20, 2026 at 12:57 AM Narayanan Venkateswaran
<narayananvpostgres(at)gmail(dot)com> wrote:
>
> Hi,
>
> On Mon, Oct 19, 2026 at 5:03 PM Narayanan Venkateswaran
> <narayananvpostgres(at)gmail(dot)com> wrote:
> >
> > Hi Nitin,
> >
> > Thank you very much for the review!
> >
> > On Sun, Oct 18, 2026 at 11:45 AM Nitin Motiani <nitinmotiani(at)google(dot)com> wrote:
> > >
> > > On Wed, Oct 14, 2026 at 7:06 PM Narayanan Venkateswaran
> > > <narayananvpostgres(at)gmail(dot)com> wrote:
> > > >
>
> > > Thanks for the patch. It seems to work fine. I think it would be good
> > > to make the same change for JSON_ARRAY.
.
.
.
> I am working on a follow-up patch that addresses json_array also, I
> shall submit it soon.
Please find attached the patch that fixes the problem in json_array also.
Thank you,
Narayanan
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Allow-NULL-and-UNIQUE-clauses-in-empty-JSON_OBJEC.patch | application/octet-stream | 7.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shihao zhong | 2026-10-20 02:22:21 | Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction |
| Previous Message | Narayanan Venkateswaran | 2026-10-19 19:27:59 | Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses |