Tab-completion feature ?
Hi All,
I observed an a bit strange behaviour of the Tab-completion in postgres
8.0.1
I have the following command
leda=# ALTER TABLE any_table RENAME TO
After the "TO" there is one space and the cursor is after that space
I press tab and I get
leda=# ALTER TABLE any_table RENAME TO TO
I understand that this is a bit stupid and not very useful example, but
still this is probably not an expected behaviour.
With Best Regards,
Sergey
PS In Postgres 7.4.6 there is no such problem.
------------------------------------------------------------
Sergey E. Koposov
Sternberg Astronomical Institute, Moscow University (Russia)
Max-Planck Institute for Astronomy (Germany)
Internet: math@sai.msu.ru, http://lnfm1.sai.msu.su/~math/
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
After the "TO" there is one space and the cursor is after that space
I press tab and I getleda=# ALTER TABLE any_table RENAME TO TO
What is happening is that psql is simply assuming that the first "TO"
may be the name of a column you are about to rename. It's the same
as:
ALTER TABLE any_table RENAME mycolumn TO
We can probably have the tab-completion code call up a list of column
names for comparison: not sure if is worth the trouble though.
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200504101714
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFCWZc7vJuQZxSWSsgRAoPiAKCVQHa2swRy6/jGzKGJplVv7je1mACg2Z6J
hJ8eSYiss3LDHsBQLBWrBJc=
=jjYQ
-----END PGP SIGNATURE-----