Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bMkWs-00078N-2o for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Jul 2016 23:22:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bMkWr-0001Q9-M3 for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Jul 2016 23:22:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bMkWq-0001OK-P3 for pgsql-bugs@postgresql.org; Mon, 11 Jul 2016 23:22:20 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bMkWn-0000k3-6y for pgsql-bugs@postgresql.org; Mon, 11 Jul 2016 23:22:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1468279337; x=1499815337; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=Y0VsxQB6maown7karRjxjvu+Y2TEBdeV8IkTmxU38g4=; b=sFA9NonPgr2E/Xw8JoeXLI2sDAVPCUxr1T/mnukNO7lwu5Vm1TwDqHTG m/7087lXis7PAVE2BfMBjZoZ9Z1k3z7KmUXR23qkTBgj5Wc11rp/tFBS9 oolzmqK9s8Bxsi2GIkJY79eHxZE+jYen5sB/tTxwoKL4F3R/4ejoGgc41 4=; X-IronPort-AV: E=Sophos;i="5.28,348,1464652800"; d="scan'208";a="463697346" Received: from sea3-co-svc-lb6-vlan2.sea.amazon.com (HELO email-inbound-relay-71001.iad55.amazon.com) ([10.47.22.34]) by smtp-border-fw-out-9102.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 11 Jul 2016 23:22:13 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad1-ws-svc-lb91-vlan3.amazon.com [10.0.103.150]) by email-inbound-relay-71001.iad55.amazon.com (8.14.7/8.14.7) with ESMTP id u6BNM9t4003356 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=OK); Mon, 11 Jul 2016 23:22:10 GMT Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1104.5; Mon, 11 Jul 2016 23:22:02 +0000 Received: from EX13D03UWC002.ant.amazon.com (10.43.162.160) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1104.5; Mon, 11 Jul 2016 23:22:02 +0000 Received: from EX13D03UWC002.ant.amazon.com ([10.43.162.160]) by EX13D03UWC002.ant.amazon.com ([10.43.162.160]) with mapi id 15.00.1104.000; Mon, 11 Jul 2016 23:22:02 +0000 From: "Bossart, Nathan" To: Andrew Gierth , "David G. Johnston" CC: Tom Lane , "pgsql-bugs@postgresql.org" Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail Thread-Topic: [BUGS] BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail Thread-Index: AQHR28p6vX56f97jDkGuKx7yZWkLTKAT3iiA Date: Mon, 11 Jul 2016 23:22:02 +0000 Message-ID: References: <20160711223641.1426.86096@wrigleys.postgresql.org> <14434.1468277346@sss.pgh.pa.us> <87oa633gzm.fsf@news-spur.riddles.org.uk> In-Reply-To: <87oa633gzm.fsf@news-spur.riddles.org.uk> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.162.39] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Precedence: Bulk X-Pg-Spam-Score: -15.8 (---------------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org I cannot speak to any real use-cases beyond easily altering current_user ev= ery time you start a session. Besides disallowing this parameter in ALTER ROLE SET statements entirely, p= erhaps pg_dumpall could simply skip it for missing roles? I cannot think o= f a use-case for maintaining an invalid setting here. Nathan --=20 Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs