Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Date: 2016-07-11 23:22:02
Message-ID: b7d103be7cbc4714963e6326c802b023@EX13D03UWC002.ant.amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I cannot speak to any real use-cases beyond easily altering current_user every time you start a session.

Besides disallowing this parameter in ALTER ROLE SET statements entirely, perhaps pg_dumpall could simply skip it for missing roles? I cannot think of a use-case for maintaining an invalid setting here.

Nathan

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-07-11 23:22:12 Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Previous Message Andrew Gierth 2016-07-11 23:18:06 Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail