Обсуждение: 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 get > > leda=# 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-----