Re: createuser unexpectedly creates superuser with createdb and createrole

2023-09-04 Thread Laurenz Albe
On Tue, 2023-09-05 at 00:03 +0200, Erik Wienhold wrote: > On 04/09/2023 03:42 CEST Tom Lane wrote: > > I think the last hunk of this is plenty sufficient, and the earlier > > ones just add noise. > > Done. Looks good to me. Yours, Laurenz Albe

Re: createuser unexpectedly creates superuser with createdb and createrole

2023-09-04 Thread Erik Wienhold
On 04/09/2023 03:42 CEST Tom Lane wrote: > I think the last hunk of this is plenty sufficient, and the earlier > ones just add noise. Done. -- ErikFrom 7728fcab53c8e06c781f7347532cc8619799d8ff Mon Sep 17 00:00:00 2001 From: Erik Wienhold Date: Mon, 4 Sep 2023 23:50:33 +0200 Subject: [PATCH v2]

Re: createuser unexpectedly creates superuser with createdb and createrole

2023-09-03 Thread Tom Lane
Erik Wienhold writes: > Anyway, I prepared a patch for the docs. I think the last hunk of this is plenty sufficient, and the earlier ones just add noise. regards, tom lane

Re: createuser unexpectedly creates superuser with createdb and createrole

2023-09-03 Thread Erik Wienhold
On 30/08/2023 03:21 CEST Laurenz Albe wrote: > I am somewhat surprised too, but it has been like that since commit 8ae0d476a9 > in 2005. Yeah, unlikely to find out why after 18 years. > The code is pretty clear about that: > > if (superuser == TRI_YES) > { > /* Not much point in

Re: createuser unexpectedly creates superuser with createdb and createrole

2023-08-29 Thread Laurenz Albe
On Wed, 2023-08-30 at 02:44 +0200, Erik Wienhold wrote: > I recently created a superuser with createuser on 15.4 and was surprised that > the superuser also has the CREATEDB and CREATEROLE attribute (although > redundant > for a superuser).  The docs [1] even say that --no-createdb and > --no-cre