Обсуждение: Tab-completion feature ?

Поиск
Список
Период
Сортировка

Tab-completion feature ?

От
"Sergey E. Koposov"
Дата:
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/




Re: Tab-completion feature ?

От
"Greg Sabino Mullane"
Дата:
-----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-----