On Tue, Oct 25, 2011 at 1:39 PM, Magnus Hagander <[email protected]> wrote: > On Mon, Oct 24, 2011 at 16:37, Keith Fiske <[email protected]> wrote: >> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane <[email protected]> wrote: >>> "Keith Fiske" <[email protected]> writes: >> >>>> If you create a user as a NONsuperuser, >>>> then later ALTER them to be one, they will NOT have the replication >>>> permission and cannot be used as a replication user until you explicitly >>>> grant that permission. >>> >>> That doesn't sound to me like a bug. These flags are independent, we >>> just provide a certain default at role creation time. >>> >> >> That is not what the documentation as read would lead people to >> believe. I'd be more than happy to help with clarifying the >> documentation myself if needed. Just let me know how. > > This part I agree with - it makes sense for ALTER to set both flags > when it enables superuser.
+1 Change the behaviour to match the docs makes most sense to me. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
