On Wed, Mar 29, 2006 at 10:19:51PM -0500, Tom Lane wrote: > Philip Yarra <[EMAIL PROTECTED]> writes: > > Hi folks, I've found that CVS HEAD psql's \c doesn't quite behave as > > expected > > Yeah, there were complaints about this already. I think the problem was > introduced by this patch:
I sent one patch to fix this, which went ignored, and Volkan Yazici sent another one, to which the same thing happened. Cheers, D > > 2006-02-11 21:54 momjian > > * doc/src/sgml/ref/psql-ref.sgml, src/bin/psql/command.c, > src/bin/psql/help.c: Please find enclosed a patch that lets you use > \c to connect (optionally) to a new host and port without exiting > psql. This eliminates, IMHO, a surprise in that you can now > connect to PostgreSQL on a differnt machine from the one where you > started your session. This should help people who use psql as an > administrative tool. > > David Fetter > > The patch seems not to behave very reasonably with respect to preserving > prior values for the newly-changeable connection parameters. I haven't > got time to look into it myself right now though --- do you want to? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(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