Re: Default Roles

On 04/07/2016 09:50 PM, Stephen Frost wrote:
> Robert, José,
>
> I've rebased this on top of master and added a few additional checks and
> regression tests.

Applies and compiles cleanly, of course. Passes all 164 tests, too.
- make installcheck-world ok
- interdiff checked, nothing very surprising

*Tests: using "pg_abcdef"  (very unlikely to ever exist) is indeed better than 
using "pg_backup" to test system 'reservedness'

*Documentation: changes seem to make it less repetitive regarding 
"pg_signal_backend". Should reduce diff size when future system roles 
get added ;)

*Code:
    Spotted the added    if (strncmp(*newval, "pg_", 3) == 0)    at src/backend/commands/variable.c    (plus
pre-existing)src/bin/pg_dump/pg_dumpall.c
 

I hadn't realized it could be needed there... I'm not familiar enough 
with the code just yet.

I reckon there's no need to add a separate helper to check this at the 
moment; might be needed later, when the superuser review patches get 
merged :)

> I'm planning to continue going over the patch tomorrow morning with
> plans to push this before the feature freeze deadline.

Good. Thank you for the effort.
    / J.L.