On Sat, Jul 11, 2015 at 6:06 AM, Heikki Linnakangas wrote: > On 05/08/2015 07:35 AM, Stephen Frost wrote: >> In consideration of the fact that you can't create schemas which start >> with "pg_" and therefore the default search_path wouldn't work for that >> user, and that we also reserve "pg_" for tablespaces, I'm not inclined >> to worry too much about this case. Further, if we accept this argument, >> then we simply can't ever provide additional default or system roles, >> ever. That'd be a pretty narrow corner to have painted ourselves into. > > > Well, you could still provide them through some other mechanism, like > require typing "SYSTEM ROLE pg_backup" any time you mean that magic role. > But I agree, reserving pg_* is much better. I wish we had done it when we > invented roles (6.5?), so there would be no risk that you would upgrade from > a system that already has a "pg_foo" role. But I think it'd still be OK. > > I agree with Robert's earlier point that this needs to be split into > multiple patches, which can then be reviewed and discussed separately. > Pending that, I'm going to mark this as "Waiting on author" in the > commitfest.
... And now marked as returned with feedback. -- Michael -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers