From: | Noah Misch <noah(at)leadboat(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gilles Darold <gilles(dot)darold(at)dalibo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS |
Date: | 2014-11-14 14:19:01 |
Message-ID: | 20141114141901.GA815495@tornado.leadboat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Nov 14, 2014 at 08:35:25AM -0500, Stephen Frost wrote:
> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> > Noah Misch <noah(at)leadboat(dot)com> writes:
> > > On Thu, Nov 13, 2014 at 08:24:36PM -0500, Stephen Frost wrote:
> > >> Agreed. I'll take care of both and we'll make sure the new role
> > >> attributes being added will do the same for upgrades also.
> >
> > > That would make pg_dumpall less faithful for every role other than the
> > > bootstrap superuser, a net loss. It would be defensible to do this for
> > > BOOTSTRAP_SUPERUSERID only.
> >
> > Huh? It seems difficult to argue that it's "less faithful" to do this
> > when the previous version didn't have the concept at all.
>
> I believe what Noah is pointing out is that we'll end up adding
> attributes which weren't there already for superusers created by users.
Yes.
> There's a couple ways to address this-
>
> Stop enabling all the role attribute bits for the bootstrap superuser,
> in which case it'd look a lot more like other superusers that a user
> might create (at least, in my experience, no one bothers to set the role
> attributes beyond superuser in real environments).
>
> or [...]
> Personally, I'm leaning towards the first as it's less clutter in the
> output of psql.
I'd agree for a new design, but I see too little to gain from changing it now.
Today's behavior is fine.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-11-14 14:35:14 | Re: Customized Options Threshold Error |
Previous Message | Stephen Frost | 2014-11-14 13:35:25 | Re: Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS |