Postgres Pro
Downloads
Home   >   mailing lists

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

From Nick Barnes
Subject Error when editing char(n)[] cells
Date
Msg-id CAG+WGGm+EfRUXekepvyaa+ngiNMQhNTO_5_vaWk1s3c1BKAZrA@mail.gmail.com
Whole thread Raw
Responses Re: Error when editing char(n)[] cells  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List pgadmin-hackers
Tree view
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

pgadmin-hackers by date:

Previous
From: Ganesh Jaybhay
Date:
Subject: Re: [pgAdmin4][RM#5107] Add tab navigation for buttons in filemanager dialogue
Next
From: Aditya Toshniwal
Date:
Subject: [pgAdmin][RM4993] [Accessibility] Read-only controls and disabledcontrols needs to be separately identified