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/



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-----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=2529DF...9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFCWZc7vJuQZxSWSsgRAoPiAKCVQHa2swRy6/jGzKGJplVv7je1mACg2Z6J
hJ8eSYiss3LDHsBQLBWrBJc=
=jjYQ
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)