Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UAgXL-0002nv-Kx for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Feb 2013 12:55:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UAgXL-0002Fj-4M for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Feb 2013 12:55:07 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UAgXI-0002Cx-JR for pgsql-hackers@postgreSQL.org; Wed, 27 Feb 2013 12:55:04 +0000 Received: from smtp-outbound-2.vmware.com ([208.91.2.13]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UAgXF-0002l1-I4 for pgsql-hackers@postgreSQL.org; Wed, 27 Feb 2013 12:55:03 +0000 Received: from sc9-mailhost1.vmware.com (sc9-mailhost1.vmware.com [10.113.161.71]) by smtp-outbound-2.vmware.com (Postfix) with ESMTP id 0D99D289BA; Wed, 27 Feb 2013 04:55:00 -0800 (PST) Received: from zcs-prod-ext-mta-1.vmware.com (zcs-prod-ext-mta-1.vmware.com [10.113.62.223]) by sc9-mailhost1.vmware.com (Postfix) with ESMTP id 0A75218648; Wed, 27 Feb 2013 04:55:00 -0800 (PST) Received: from localhost (localhost.localdomain [127.0.0.1]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTP id 5EB5A1219C5; Wed, 27 Feb 2013 04:58:19 -0800 (PST) X-Virus-Scanned: amavisd-new at zcs-prod-ext-mta-1.vmware.com Received: from zcs-prod-ext-mta-1.vmware.com ([127.0.0.1]) by localhost (zcs-prod-ext-mta-1.vmware.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id I_-rtumcZk4C; Wed, 27 Feb 2013 04:58:19 -0800 (PST) Received: from zcs-prod-ext-mta-1.vmware.com (localhost.localdomain [127.0.0.1]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTP id 3AFFF1219C2; Wed, 27 Feb 2013 04:58:19 -0800 (PST) Received: from [192.168.1.90] (unknown [10.113.62.14]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTPSA; Wed, 27 Feb 2013 04:58:18 -0800 (PST) Message-ID: <512E021D.1050109@vmware.com> Date: Wed, 27 Feb 2013 14:54:53 +0200 From: Heikki Linnakangas Organization: VMware User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.12) Gecko/20130116 Icedove/10.0.12 MIME-Version: 1.0 To: Thom Brown CC: PostgreSQL-development Subject: Re: [COMMITTERS] pgsql: Fix pg_dumpall with database names containing = References: <512CE2D6.2010204@vmware.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -7.6 (-------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 27.02.2013 11:52, Thom Brown wrote: > Once I'm in that database, I can't switch user from within psql: > > 8=8=# \c - moo > invalid connection option "8" > Previous connection kept Hmm, true. Also, any other connection options you specified in the original connection string are lost. For example, if you first connected with: psql "dbname=foo sslmode=require" and then did "\c - anotheruser", the second connection would not require ssl. - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers