Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jNuZN-0007G7-Gp for pgadmin-hackers@arkaria.postgresql.org; Mon, 13 Apr 2020 08:35:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jNuZM-00069p-8r for pgadmin-hackers@arkaria.postgresql.org; Mon, 13 Apr 2020 08:35:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jNuZL-00069g-UT for pgadmin-hackers@lists.postgresql.org; Mon, 13 Apr 2020 08:35:52 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jNuZJ-0002W2-BN for pgadmin-hackers@postgresql.org; Mon, 13 Apr 2020 08:35:50 +0000 Received: by mail-io1-xd30.google.com with SMTP id w1so8615786iot.7 for ; Mon, 13 Apr 2020 01:35:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=pURSrrrmyUaz1AX9+qUtscmUGdGqpIcaZL7SzA1A8mI=; b=gKmWFDWhA1HWLhb0x68RqwhfE5/jDIJTjb3AlGO8Mp8NY8ene6kGuS1raZuG01O+ip UInLj1mG5tVWZ1uXW4ygBckFBAGZpVYFr09UwN5TperhcYCKgUkcbqNxxMaZ7RiX+rwm EjgFE5BhJj3fKLRSCzmhI73UHUqqq4I4Y2HTW3DUbmmglrnoCTJU0D/vZ2ogkAUmN55y HXxJ8u5qZGPSNgW3pETHvYlyKQfCTapjzUo+Met6M0yuZucTFi7gwEjElla1DoQAHY5M y6IaFWihycgf+BBhbGB6CJE2lW1FK7QdItjEPLS2l6XGZ0qOHavUj9Ie2HiSWpq4E9M1 ep+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=pURSrrrmyUaz1AX9+qUtscmUGdGqpIcaZL7SzA1A8mI=; b=ZW6/ZbTN9j44qDxWeOkt7wFCLH8kAGw63TF+kevBSWjJOOxb6tEHeCwJZL8jWxky7O DrwOtOMo0UeAnDcBpmlM8RnBiowQ7iufV6Se4nB8NSyagBxWLQAmOOJdopa+1nNJGCAn ly2Uly8WUcyn3pRdFjYAuF12LA8i6mqGJe7323nYjh1C/6BMQzKzOoJo9DsYW0Bm9T3s RRcG2dcgrkfSxaXZk/HgMCuG9LOOiJC5fJIq0Uw3euMtAIYv8T+AO4uYnB0RNp9KXzgw ZVot8U86eWaCTfqkzy3zPa1uD7wh/IGlgtEMb11rtx/Y48dDAlAuqy5NhZtPxFtUnPnF 2Yrw== X-Gm-Message-State: AGi0PuYFblZeeIXziPPX3Lqw0J9MR+aMPE3xS4Nrv4hbZ1tq0AP8RGAk UiaYhfl1yELiAwpcRY20rhskxJUNw8O/4PCpOofOZqOD8RDMKKXxMpG4PTJTfnEDyamP7ifdv3t Ue1E5dib74zG1cUjc2gXxHtC232GzVApjtJNPkaqH81ik7GGQBDlyuaNGQ5gmPFbVDxdNZvWTbz rG1RlxJNaG8EM0NIPZBJUevmslUIW1oFcpur0QvpP+txkXTBtre3Q= X-Google-Smtp-Source: APiQypLhlzDgERdxu6ux5HbBtlyTaQ/tEE2XRO2fUOvLsy7tFic3sLfWntSZTAdBCL553uxLtzL2P8e9W7jUIe2w1l4= X-Received: by 2002:a02:6f17:: with SMTP id x23mr14307394jab.1.1586766947132; Mon, 13 Apr 2020 01:35:47 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Mon, 13 Apr 2020 14:05:36 +0530 Message-ID: Subject: Re: [pgAdmin][RM4969] JSONB and JSON field editing To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="00000000000039bfa505a327f8fc" X-CLOUD-SEC-AV-Info: edb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000039bfa505a327f8fc Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Fri, Apr 10, 2020 at 11:49 AM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > Hi Hackers, > > Attached is the patch fix issue for jsonb and json field editing. Making > the field blank throws a validation error. The patch will set json, jsonb > to null when set to blank. > > Please review. > > -- > Thanks and Regards, > Aditya Toshniwal > pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune > "Don't Complain about Heat, Plant a TREE" > -- *Thanks & Regards* *Akshay Joshi* *Sr. Software Architect* *EnterpriseDB Software India Private Limited* *Mobile: +91 976-788-8246* --00000000000039bfa505a327f8fc Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Fri, Apr 10, 2020 at 11:49 AM Adi= tya Toshniwal <adit= ya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

Attached is the= patch fix issue for jsonb and json field editing. Making the field blank t= hrows a validation error. The patch will set json, jsonb to null when set t= o blank.

Please review.

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer |=C2=A0Ente= rpriseDB India |=C2=A0Pune
"Don't Complain about Heat, Plant a TREE"<= /div>


--
Thanks & Regards
=
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited
=
Mobile: += 91 976-788-8246
--00000000000039bfa505a327f8fc--