Re: [pgAdmin4][RM3912] Unable to save data if user update primary key with Json data type

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][RM3912] Unable to save data if user update primary key with Json data type
Date: 2019-02-20 11:15:53
Message-ID: CA+OCxoxm7d6byuJ1sbVS7_as9+MGawFbZs-On2Ny0298SgUT7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks - patch applied!

On Wed, Feb 20, 2019 at 4:22 AM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi Hackers,
>
> Attached is the patch to fix the issue where updating data (using
> view/edit) of primary key column where data type of that column is
> json/jsonb throws exception psycopg2.ProgrammingError: can't adapt type '
> dict'.
> The adapt function of psycopg2 does not support dict data type. Instead,
> http://initd.org/psycopg/docs/extras.html#json-adaptation can be used.
>
> Kindly review.
>
> Thanks and Regards,
> Aditya Toshniwal
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB Software Solutions | Pune
> "Don't Complain about Heat, Plant a tree"
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2019-02-20 11:49:49 pgAdmin 4 commit: Modify the Download as CSV option to use the same con
Previous Message Dave Page 2019-02-20 11:15:44 pgAdmin 4 commit: Fix editing of table data with a JSON primary key. Fi