Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bMkTW-0006qV-Uu for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Jul 2016 23:18:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bMkTW-00016B-7z for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Jul 2016 23:18:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bMkSs-0000OT-I0 for pgsql-bugs@postgresql.org; Mon, 11 Jul 2016 23:18:14 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bMkSp-00080P-Gw for pgsql-bugs@postgresql.org; Mon, 11 Jul 2016 23:18:13 +0000 Received: from localhost ([127.0.0.1]:17441 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtp (Exim 4.84 (FreeBSD)) (envelope-from ) id 1bMkSl-0008wv-3i; Mon, 11 Jul 2016 23:18:07 +0000 From: Andrew Gierth To: "David G. Johnston" Cc: Tom Lane , "bossartn\@amazon.com" , "pgsql-bugs\@postgresql.org" Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail In-Reply-To: (David G. Johnston's message of "Mon, 11 Jul 2016 19:03:22 -0400") Message-ID: <87oa633gzm.fsf@news-spur.riddles.org.uk> References: <20160711223641.1426.86096@wrigleys.postgresql.org> <14434.1468277346@sss.pgh.pa.us> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (berkeley-unix) Date: Tue, 12 Jul 2016 00:18:06 +0100 MIME-Version: 1.0 Content-Type: text/plain X-Pg-Spam-Score: -3.2 (---) 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 >>>>> "David" == David G Johnston writes: >> > 2. As foo, execute "alter role foo set role = 'foo'" David> I'm at a loss to understand what this does when it isn't broken. ALTER ROLE foo SET role = bar; will have the effect that when 'foo' logs in, it will behave as if foo had immediately executed the command SET ROLE bar; I don't think this is documented but it has obvious uses. -- Andrew (irc:RhodiumToad) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs