Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail - Mailing list pgsql-bugs

From Bossart, Nathan
Subject Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Date
Msg-id b7d103be7cbc4714963e6326c802b023@EX13D03UWC002.ant.amazon.com
Whole thread Raw
In response to Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail