On Tue, 2006-01-31 at 20:53 -0500, Bruce Momjian wrote: > Rod Taylor wrote: > > On Tue, 2006-01-31 at 20:18 -0500, Bruce Momjian wrote: > > > Christopher Kings-Lynne wrote: > > > > It could read all the SET variables in at startup? > > > > > > Right, but do we want to do that even if they never ask for a tab > > > completion? I think the easiest might be to just save the list on first > > > tab call. > > > > As mentioned earlier the problem exists for all tab completion in > > aborted transactions. > > > > Perhaps a second database connection could be established during > > situations when running tab completion and other psql commands is > > impossible on the main one? > > What if you need a password to be supplied?
I believe psql keeps the password in memory. \c seems to be able to change databases without asking for the password again. -- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match