Skip site navigation (1) Skip section navigation (2)

Re: psql \c error

From: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Philip Yarra <philip(at)utiba(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: psql \c error
Date: 2006-03-30 03:23:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Wed, Mar 29, 2006 at 10:19:51PM -0500, Tom Lane wrote:
> Philip Yarra <philip(at)utiba(dot)com> 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.

> 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 <david(at)fetter(dot)org>
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2006-03-30 03:31:21
Subject: Re: control pg_hba.conf via SQL
Previous:From: Tom LaneDate: 2006-03-30 03:19:51
Subject: Re: psql \c error

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group