Thread: Previous command not accessible in postgres 17 beta

Previous command not accessible in postgres 17 beta

From
usman khan
Date:
Dear Concerned,
I wanted to let you know that I am running postgres 17 in rocky linux and when I tries to fetch previous command by pressing up arrow key than instead of fetching previous key, I am getting following values:
^[[A^[[A^[[B^[[A
Please look into this.

Thank You

Re: Previous command not accessible in postgres 17 beta

From
Tom Lane
Date:
usman khan <usman.khan9805@gmail.com> writes:
> I wanted to let you know that I am running postgres 17 in rocky linux and
> when I tries to fetch previous command by pressing up arrow key than
> instead of fetching previous key, I am getting following values:
> ^[[A^[[A^[[B^[[A

Nothing around that has changed in Postgres.  The likely cause is
either that your new psql was built without readline support, or
that you have the wrong TERM setting so that what your keyboard
emits for up-arrow is not what readline is expecting.

            regards, tom lane



RE: [EXTERNAL] Re: Previous command not accessible in postgres 17 beta

From
"Wetmore, Matthew (CTR)"
Date:
I had a new ubuntu install (JJ)  and when I installed from source, I hit Readline error in with GCC.

I had to manually download libReadline-dev (or whatever it's exact name is)

not sure if it was mysetup, or Ubuntu or Source.

so if everything installed, Readline is probably OK.

I would look at Tom's second advice with TERM.

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, June 13, 2024 7:34 AM
To: usman khan <usman.khan9805@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: Previous command not accessible in postgres 17 beta

usman khan <usman.khan9805@gmail.com> writes:
> I wanted to let you know that I am running postgres 17 in rocky linux
> and when I tries to fetch previous command by pressing up arrow key
> than instead of fetching previous key, I am getting following values:
> ^[[A^[[A^[[B^[[A

Nothing around that has changed in Postgres.  The likely cause is either that your new psql was built without readline
support,or that you have the wrong TERM setting so that what your keyboard emits for up-arrow is not what readline is
expecting.

            regards, tom lane


----------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the
addressshown. This email transmission may contain confidential information.  This information is intended only for the
useof the individual(s) or entity to whom it is intended even if addressed incorrectly.  Please delete it from your
filesif you are not the intended recipient.  Thank you for your compliance.  Copyright (c) 2024 Evernorth 



Hello,
Thank you for the response. It is solved now using readline library

On Thu, Jun 13, 2024 at 8:08 PM Wetmore, Matthew (CTR) <Matthew.Wetmore@evernorth.com> wrote:
I had a new ubuntu install (JJ)  and when I installed from source, I hit Readline error in with GCC.

I had to manually download libReadline-dev (or whatever it's exact name is)

not sure if it was mysetup, or Ubuntu or Source.

so if everything installed, Readline is probably OK.

I would look at Tom's second advice with TERM.

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, June 13, 2024 7:34 AM
To: usman khan <usman.khan9805@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: Previous command not accessible in postgres 17 beta

usman khan <usman.khan9805@gmail.com> writes:
> I wanted to let you know that I am running postgres 17 in rocky linux
> and when I tries to fetch previous command by pressing up arrow key
> than instead of fetching previous key, I am getting following values:
> ^[[A^[[A^[[B^[[A

Nothing around that has changed in Postgres.  The likely cause is either that your new psql was built without readline support, or that you have the wrong TERM setting so that what your keyboard emits for up-arrow is not what readline is expecting.

                        regards, tom lane


----------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information.  This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly.  Please delete it from your files if you are not the intended recipient.  Thank you for your compliance.  Copyright (c) 2024 Evernorth