Thread: Error when editing char(n)[] cells

Error when editing char(n)[] cells

From

Nick Barnes

Date:

21 January 2020, 13:25:06

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

Attachment

0001-Fix-invalid-format-specifiers.-Fixes-4410.patch

Re: Error when editing char(n)[] cells

From

Akshay Joshi

Date:

23 January 2020, 09:27:21

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