Postgres Pro
Downloads
Home   >   mailing lists

[pgAdmin4][RM3912] Unable to save data if user update primary keywith Json data type - Mailing list pgadmin-hackers

From Aditya Toshniwal
Subject [pgAdmin4][RM3912] Unable to save data if user update primary keywith Json data type
Date
Msg-id CAB2fNHCW7+BXqBjcxm7=L6tCZEMsEzgkB6+tAkTDDiGiZqLRVg@mail.gmail.com
Whole thread Raw
Responses Re: [pgAdmin4][RM3912] Unable to save data if user update primary keywith Json data type
List pgadmin-hackers
Tree view
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
Attachment

pgadmin-hackers by date:

Previous
From: Akshay Joshi
Date:
Subject: [pgAdmin4][Patch]: RM #3958 Query Tool commits after SELECTstatements regardless of 'Auto commit' setting
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Convert the JSON output from yarn properly