Can't execute safe multiline query in Emacs mode

[benthorner]

Description

I've started using pgcli recently and would really like to use "safe" multiline mode, but I can't get it to work: whenever I press "[esc] [enter]" I just get a newline. In fact, I can't find any key combination that will actually execute the query!

Here's a video to illustrate what I mean:

https://user-images.githubusercontent.com/9029009/181935720-8bd5acd9-4c20-4020-8f82-5017d4346799.mov

As you can see, I'm definitely pressing escape and enter at the same time. Interestingly, it does work as expected in vi mode, but I really want to use emacs mode. I don't have any keyboard issues with any other apps or tools.

I can't find any other reports of this issue, but also struggle to believe I'm doing anything unusual.

Does anyone have any ideas why I can't execute queries?

Your environment

• OS version: Mac Monterey (12.4 / 12.5)

I get the same behaviour on my old Macbook Pro 2015 and my Macbook M1 2021.

• CLI version: 3.4.1

I've also tried installing older versions - down to v2 - and still get the same behaviour.

• pip freeze: N/A (installed with Homebrew)

I do use pyenv and tried older versions in a global virtualenv. Here's pip freeze:

pip freeze output

appnope==0.1.2
asgiref==3.5.0
async-timeout==4.0.2
attrs==21.2.0
backcall==0.2.0
bleach==3.3.0
certifi==2020.12.5
cffi==1.15.0
chardet==4.0.0
colorama==0.4.4
cryptography==37.0.2
cssselect2==0.6.0
decorator==4.4.2
defusedxml==0.7.1
Deprecated==1.2.13
Django==3.2.13
django-extensions==2.2.5
docutils==0.16
easy-thumbnails==2.8.1
flake8==4.0.1
idna==2.10
iniconfig==1.1.1
ipython-genutils==0.2.0
isort==5.10.1
jedi==0.18.0
keyring==22.0.1
lxml==4.8.0
mccabe==0.6.1
-e git+ssh://[email protected]/benthorner/mock_serial.git@93e93e3a532570578ab9afa1058f70ae2cc19e9d#egg=mock_serial
mypy==0.961
mypy-extensions==0.4.3
oauthlib==3.2.0
packaging==20.9
parso==0.8.1
pexpect==4.8.0
pickleshare==0.7.5
Pillow==9.1.0
pkginfo==1.7.0
pluggy==1.0.0
prompt-toolkit==3.0.10
ptyprocess==0.7.0
py==1.11.0
pycodestyle==2.8.0
pycparser==2.21
pyflakes==2.4.0
Pygments==2.7.3
PyJWT==2.3.0
pyOpenSSL==22.0.0
pyparsing==2.4.7
pyserial==3.5
pytest==6.2.5
python-dotenv==0.19.1
python3-openid==3.2.0
pytz==2022.1
readme-renderer==28.0
redis==4.3.1
reportlab==3.6.9
requests==2.25.1
requests-oauthlib==1.3.1
requests-toolbelt==0.9.1
rfc3986==1.4.0
six==1.15.0
social-auth-app-django==5.0.0
social-auth-core==4.2.0
sqlparse==0.4.2
svglib==1.2.1
tinycss2==1.1.1
toml==0.10.2
tomli==2.0.1
tqdm==4.56.2
traitlets==5.0.5
twine==3.3.0
typing_extensions==4.3.0
urllib3==1.26.3
wcwidth==0.2.5
webencodings==0.5.1
Werkzeug==0.16.0
wrapt==1.14.1

I've tried disabling all my zsh config and using iTerm instead of Mac's Terminal.