Autocomplete offers no columns after one column named 'type'

[ShootingStar91]

Description

I work with a table that has a column named type

If I write a query like: SELECT type, name, id FROM table;

Then after typing the column name type, I will not get any autocomplete suggestions for column names. I will get those before typing "type". The feature only suggests table names after "type". Also type is highlighted as it is a non-reserving keyword, rightly so I believe.

Your environment

Ubuntu 22.04.2
pgcli 3.3.1

Pip freeze:
agate==1.6.3
agate-dbf==0.2.2
agate-excel==0.2.5
agate-sql==0.5.8
ansible-base==2.10.8
apache-libcloud==3.2.0
appdirs==1.4.4
apptools==5.1.0
apt-xapian-index==0.49
apturl==0.5.2
argcomplete==1.8.1
argon2-cffi==21.1.0
asciitree==0.3.3
astroid==2.9.3
astropy==5.0.2
asttokens==2.0.5
attrs==21.2.0
autobahn==21.11.1
Automat==20.2.0
autopep8==1.6.0
ayatana-settings==21.1.28
Babel==2.8.0
backcall==0.2.0
base58==1.0.3
bcrypt==3.2.0
beautifulsoup4==4.10.0
beniget==0.4.1
bitarray==1.6.3
bleach==4.1.0
blinker==1.4
blosc==1.9.2
Bottleneck==1.3.2
breezy==3.2.1
Brlapi==0.8.3
Brotli==1.0.9
CacheControl==0.12.10
cachetools==5.0.0
cachy==0.3.0
cajarename==21.11.24
cbor==1.0.0
cdo==1.5.6
certifi==2020.6.20
cffi==1.15.0
cftime==1.5.2
chardet==4.0.0
cleo==0.8.1
cli-helpers==2.2.1
click==8.0.3
clikit==0.6.2
cloudpickle==2.0.0
colorama==0.4.4
command-not-found==0.3
configobj==5.0.6
constantly==15.1.0
cov-core==1.15.0
coverage==6.2
crashtest==0.3.1
cryptography==3.4.8
css-parser==1.0.7
cssutils==1.0.2
csvkit==1.0.6
cupshelpers==1.0
cutadapt==3.5
cycler==0.11.0
Cython==0.29.28
dask==2022.1.0+dfsg
dbfread==2.0.7
dbus-python==1.2.18
decorator==4.4.2
defer==1.0.6
defusedxml==0.7.1
deja-dup-caja==0.0.9
Deprecated==1.2.13
descartes==1.1.0
devscripts===2.22.1ubuntu1
distlib==0.3.4
distributed==2022.1.0+ds.1
distro==1.7.0
distro-info===1.1build1
dnaio==0.7.1
dnspython==2.1.0
dropbox==11.26.0
dulwich==0.20.31
duplicity==0.8.21
ecdsa==0.18.0b1
entrypoints==0.4
envisage==6.0.1
et-xmlfile==1.0.1
fastbencode==0.0.5
fasteners==0.14.1
fastimport==0.9.14
filelock==3.6.0
flatbuffers===1.12.1-git20200711.33e2d80-dfsg1-0.6
folder-color-caja==0.0.86
folder-color-common==0.0.86
fonttools==4.29.1
fs==2.4.12
fsspec==2022.1.0
fuse-python==1.0.2
fusepy==3.0.1
future==0.18.2
gajim==1.3.3
gast==0.5.2
GDAL==3.4.1
geographiclib==1.52
geopy==2.2.0
google-api-python-client==1.7.11
google-auth==1.5.1
google-auth-httplib2==0.1.0
gpg===1.16.0-unknown
greenlet==1.1.2
gssapi==1.6.12
h5netcdf==0.12.0
h5py==3.6.0
h5py.-debian-h5py-serial==3.6.0
HeapDict==1.0.1
html5lib==1.1
httplib2==0.20.2
hyperlink==21.0.0
hypothesis==6.36.0
idna==3.3
img2pdf==0.4.2
importlib-metadata==4.6.4
incremental==21.3.0
iniconfig==1.1.1
iotop==0.6
ipykernel==6.7.0
ipython==7.31.1
ipython_genutils==0.2.0
ipywidgets==6.0.0
isodate==0.6.1
isort==5.6.4
jdcal==1.0
jedi==0.18.0
jeepney==0.7.1
Jinja2==3.0.3
jmespath==0.10.0
joblib==0.17.0
jsonschema==3.2.0
jupyter-client==7.1.2
jupyter-core==4.9.1
jupyterlab-pygments==0.1.2
keyring==23.5.0
kiwisolver==1.3.2
language-selector==0.1
launchpadlib==1.10.16
lazr.restfulclient==0.14.4
lazr.uri==1.0.6
lazy-object-proxy==0.0.0
leather==0.3.4
libarchive-c==2.9
libhfst_swig==3.15.4b0
llvmlite==0.38.0
locket==0.2.1
lockfile==0.12.2
logilab-common==1.8.2
louis==3.20.0
lxml==4.8.0
lz4==3.1.3+dfsg
macaroonbakery==1.3.1
Magnus==1.0.3
Mako==1.1.3
Markdown==3.3.6
MarkupSafe==2.0.1
mate-hud==22.4.4
mate-tweak==22.4.8
matplotlib==3.5.1
matplotlib-inline==0.1.3
mayavi==4.7.1
mccabe==0.6.1
meld==3.20.4
mercurial==6.1.1
meson==0.61.2
mne==0.23.4
mnemonic==0.19
mock==4.0.3
monotonic==1.6
more-itertools==8.10.0
mpi4py==3.1.3
mpmath==0.0.0
msgpack==1.0.3
mypy-extensions==0.4.3
mysqlclient==1.4.6
nbclient==0.5.6
nbconvert==6.4.0
nbformat==5.1.3
nbxmpp==2.0.4
nest-asyncio==1.5.4
netaddr==0.8.0
netCDF4==1.5.8
netifaces==0.11.0
nibabel==3.2.2
nose==1.3.7
nose2==0.9.2
notebook==6.4.8
ntlm-auth==1.4.0
numba==0.55.1
numcodecs==0.9.1+ds
numexpr==2.8.1
numpy==1.21.5
oauth2client==4.1.3
oauthlib==3.2.0
odfpy==1.4.2
olefile==0.46
onboard==1.4.1
openpyxl==3.0.9
OWSLib==0.25.0
packaging==21.3
pandas==1.3.5
pandocfilters==1.5.0
paramiko==2.9.3
parsedatetime==2.6
parso==0.8.1
partd==1.2.0
passlib==1.7.4
pastel==0.2.1
patiencediff==0.2.1
patsy==0.5.2
pbr==5.8.0
pdfarranger==1.8.2
pendulum==2.1.2
pep8==1.7.1
pexpect==4.8.0
pgcli==3.3.1
pgspecial==1.11.10
pickleshare==0.7.5
pikepdf==5.0.1+dfsg
Pillow==9.0.1
pkginfo==1.8.2
platformdirs==2.5.1
plotly==5.4.0
pluggy==0.13.0
ply==3.11
poetry==1.1.12
poetry-core==1.0.7
precis-i18n==1.0.2
prometheus-client==0.9.0
prompt-toolkit==3.0.28
protobuf==3.12.4
pssh==2.3.4
psutil==5.9.0
psycopg2==2.9.2
ptyprocess==0.7.0
pulsemixer==1.5.1
py==1.10.0
py-ubjson==0.16.1
pyasn1==0.4.8
pyasn1-modules==0.2.1
pycairo==1.20.1
pycodestyle==2.8.0
pycparser==2.21
pycryptodomex==3.11.0
pycups==2.0.1
pydicom==2.2.2
pydocstyle==6.1.1
PyDrive==1.3.1
pyerfa==2.0.0.1
pyface==7.4.0
pyflakes==2.4.0
pygame==2.1.2
pygit2==1.6.1
PyGithub==1.55
Pygments==2.11.2
PyGObject==3.42.1
PyHamcrest==2.0.2
PyICU==2.8.1
pyinotify==0.9.6
PyJWT==2.3.0
pykerberos==1.1.14
pylev==1.2.0
pylibacl==0.6.0
pylibtiff==0.4.4
pylint==2.12.2
pymacaroons==0.13.0
pymol==2.5.0
PyNaCl==1.5.0
PyOpenGL==3.1.5
pyOpenSSL==21.0.0
pyparsing==2.4.7
pypng==0.0.20
pyproj==3.3.0
PyQRCode==1.2.1
PyQt5==5.15.6
PyQt5-sip==12.9.1
PyQtWebEngine==5.15.5
pyraf==2.2.0
pyRFC3339==1.1
pyrsistent==0.18.1
pysvn==1.9.15
pytest==6.2.5
pytest-arraydiff==0.5.0
pytest-astropy==0.9.0
pytest-astropy-header==0.2.0
pytest-cov==3.0.0
pytest-doctestplus==0.11.2
pytest-filter-subpackage==0.1.1
pytest-mock==3.6.1
pytest-openfiles==0.5.0
pytest-remotedata==0.3.3
python-apt==2.4.0+ubuntu1
python-axolotl==0.2.3
python-axolotl-curve25519==0.4.1.post2
python-dateutil==2.8.1
python-debian===0.1.43ubuntu1
python-gitlab==2.10.1
python-gnupg==0.4.8
python-lsp-jsonrpc==1.0.0
python-lsp-server==1.3.3
python-magic==0.4.24
python-pam==1.8.4
python-slugify==4.0.0
python-snappy==0.5.3
python-xapp==2.2.1
python-xlib==0.29
pythran==0.10.0
pytidylib==0.3.2
pytimeparse==1.1.5
PyTrie==0.4.0
pytz==2022.1
pytzdata==2020.1
pyudev==0.22.0
pywinrm==0.3.0
pyxattr==0.7.2
pyxdg==0.27
PyYAML==5.4.1
pyzmq==22.3.0
qrcode==7.3.1
QScintilla==2.11.6
reportlab==3.6.8
requests==2.25.1
requests-kerberos==0.12.0
requests-ntlm==1.1.0
requests-toolbelt==0.9.1
rope==0.22.0
rsa==4.8
rubber==1.6.0
s3cmd==2.2.0
scikit-learn==0.23.2
scipy==1.8.0
SCons==4.0.1
scour==0.38.2
seaborn==0.11.2
SecretStorage==3.3.1
selinux==3.3
Send2Trash==1.8.1b0
service-identity==18.1.0
setproctitle==1.2.2
Shapely==1.8.0
shellingham==1.4.0
simplejson==3.17.6
simpy==3.0.11
six==1.16.0
snowballstemmer==2.2.0
sortedcontainers==2.1.0
soupsieve==2.3.1
SQLAlchemy==1.4.31
sqlparse==0.4.2
ssh-import-id==5.11
stone==3.3.1
stsci.tools==4.0.1
sympy==1.9
systemd-python==234
tables==3.7.0
tabulate==0.8.9
tblib==1.7.0
tenacity==6.3.1
terminado==0.13.1
terminaltables==3.1.0
terminator==2.1.1
testpath==0.5.0
threadpoolctl==3.1.0
tinycss==0.4
tinycss2==1.1.1
toml==0.10.2
tomlkit==0.9.2
toolz==0.11.2
tornado==6.1
traitlets==5.1.1
traits==6.3.2
traitsui==7.2.1
Twisted==22.1.0
txaio==21.2.1
typing-extensions==3.10.0.2
u-msgpack-python==2.3.0
ubuntu-advantage-tools==8001
ubuntu-drivers-common==0.0.0
ufoLib2==0.13.1
ufw==0.36.1
ujson==5.1.0
unattended-upgrades==0.1
unicodedata2==14.0.0
Unidecode==1.3.3
unidiff==0.5.5
uritemplate==3.0.1
urllib3==1.26.5
virtualenv==20.13.0+ds
wadllib==1.3.6
wcwidth==0.2.5
webencodings==0.5.1
widgetsnbextension==2.0.0
wrapt==1.13.3
wsaccel==0.6.3
xarray==0.16.1
xdg==5
xkit==0.0.0
xlrd==1.2.0
xlwt==1.3.0
xmltodict==0.12.0
xopen==1.2.1
yapf==0.32.0
youtube-dl==2021.12.17
zarr==0.0.0
zict==2.0.0
zipp==1.0.0
zope.interface==5.4.0

[j-bennet]

@ShootingStar91 so you have a column named type?

[ShootingStar91]

@ShootingStar91 so you have a column named type?

That's correct

I work with a table that has a column named type