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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: [pgAdmin4][RM3912] Unable to save data if user update primary keywith Json data type
Дата
Msg-id CA+OCxoxm7d6byuJ1sbVS7_as9+MGawFbZs-On2Ny0298SgUT7g@mail.gmail.com
обсуждение исходный текст
Ответ на [pgAdmin4][RM3912] Unable to save data if user update primary keywith Json data type  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Список pgadmin-hackers
Thanks - patch applied!

On Wed, Feb 20, 2019 at 4:22 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: pgAdmin 4 commit: Fix editing of table data with a JSON primary key.Fi
Следующее
От: Dave Page
Дата:
Сообщение: pgAdmin 4 commit: Modify the Download as CSV option to use the samecon