>>>>> "David" == David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> 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)