Обсуждение: Error when editing char(n)[] cells

Поиск
Список
Период
Сортировка

Error when editing char(n)[] cells

От
Nick Barnes
Дата:
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
Вложения

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

От
Akshay Joshi
Дата:
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