| From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
|---|---|
| To: | Nick Barnes <nickbarnes01(at)gmail(dot)com> |
| Cc: | pgadmin-hackers <pgadmin-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Error when editing char(n)[] cells |
| Date: | 2020-01-23 09:27:21 |
| Message-ID: | CANxoLDeD-50PuftmrufXWTWnNm32KeOfxT=2Q3UaAtjg4m4eug@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Thanks, patch applied.
On Tue, Jan 21, 2020 at 6:55 PM Nick Barnes <nickbarnes01(at)gmail(dot)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
> <https://redmine.postgresql.org/issues/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*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aditya Toshniwal | 2020-01-23 10:31:34 | Re: pgadmin 4 wont start on redhat 8 |
| Previous Message | Akshay Joshi | 2020-01-23 09:26:40 | pgAdmin 4 commit: Fixed an issue while editing char[] or character vary |