Horton

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

Nathan Bossart <bossartn@amazon.com>

View thread View on postgr.es
From: "Bossart, Nathan" <bossartn@amazon.com>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2016-07-11T23:22:02Z
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

Commits

  1. Fix some inappropriately-disallowed uses of ALTER ROLE/DATABASE SET.