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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "bossartn\(at)amazon(dot)com" <bossartn(at)amazon(dot)com>, "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:12
Message-ID: 15762.1468279332@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> I don't think this is documented but it has obvious uses.

Does it? If the named role is the same as the actual role, then it's
useless. If they're different, it seems at best confusing. In the
context of ALTER DATABASE SET, it seems both confusing and possibly
a security hazard.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2016-07-11 23:36:05 Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Previous Message Bossart, Nathan 2016-07-11 23:22:02 Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail