Home > mailing lists

Re: Error when editing char(n)[] cells - Mailing list pgadmin-hackers

From	Akshay Joshi
Subject	Re: Error when editing char(n)[] cells
Date	January 23, 2020 12:27:21
Msg-id	CANxoLDeD-50PuftmrufXWTWnNm32KeOfxT=2Q3UaAtjg4m4eug@mail.gmail.com Whole thread Raw
In response to	Error when editing char(n)[] cells (Nick Barnes <nickbarnes01@gmail.com>)
List	pgadmin-hackers

Tree view

Thanks, patch applied.

On Tue, Jan 21, 2020 at 6:55 PM Nick Barnes <nickbarnes01@gmail.com> wrote:

Hi,

In the "View/Edit Data" grid, editing a char(n)[] or varchar(n)[] cell triggers a psycopg error: "argument formats can't be mixed". This seems to be the same issue reported in #4410.

Looks like the cause is a format() template which is using "%s" instead of "{}", leaving a literal "%s" in the generated SQL. Patch attached.

Cheers,
Nick

Thanks & Regards

Akshay Joshi

Sr. Software Architect

EnterpriseDB Software India Private Limited

Mobile: +91 976-788-8246

pgadmin-hackers by date:

From: Akshay Joshi
Date: 23 January 2020, 12:26:40
Subject: pgAdmin 4 commit: Fixed an issue while editing char[] or character vary

From: Aditya Toshniwal
Date: 23 January 2020, 13:31:34
Subject: Re: pgadmin 4 wont start on redhat 8

Re: Error when editing char(n)[] cells - Mailing list pgadmin-hackers

Previous

Next