Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nRWUU-00048X-9l
	for pgsql-docs@arkaria.postgresql.org; Tue, 08 Mar 2022 09:50:50 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nRWUT-0001yY-9D
	for pgsql-docs@arkaria.postgresql.org; Tue, 08 Mar 2022 09:50:49 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <gparc@free.fr>)
	id 1nRWUS-0001yM-Vz
	for pgsql-docs@lists.postgresql.org; Tue, 08 Mar 2022 09:50:49 +0000
Received: from smtp1-g21.free.fr ([212.27.42.1])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <gparc@free.fr>)
	id 1nRWUL-0006jt-TT
	for pgsql-docs@lists.postgresql.org; Tue, 08 Mar 2022 09:50:48 +0000
Received: from zimbra15-e2.priv.proxad.net (unknown [172.20.243.165])
	by smtp1-g21.free.fr (Postfix) with ESMTP id DF28CB0059B
	for <pgsql-docs@lists.postgresql.org>; Tue,  8 Mar 2022 10:50:38 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=free.fr;
	s=smtp-20201208; t=1646733038;
	bh=jSoJDzVJWLK7olLQe77ViATetE+nidkMQePZk+Xn4SY=;
	h=Date:From:To:In-Reply-To:Subject:From;
	b=gy3C0xUf7GGO1RthGcWzycS+tJpIk7V9jKDVCb3YwqN3rHqIAqExRUC2dfkGJgFs9
	 jiO9bVreKm3EIxvrboXVVqDuuuCDeqfKgp9/FPVXels5kwlCAbuB0jkikJjXXpeFDU
	 mrNDFs+ASVNH5sLCJJO4/CGqnonrQbfQqeKeukY0sdof2oSUm586sbrjSCmr+Lx/fc
	 B3LfPRYOP7ZpjczWu/1Vo9iX9GIpQvJK+d8u9/JJ9tIBcy0NetYxatIC7/pA/J/cbY
	 WXFy//CVU1q3WYdJeaR3Ksp8cB9J0hUAjuldA6Nzvh+lHctBFrmcBgBr/tqMTIp1Lu
	 1/eQDz25BXiqA==
Date: Tue, 8 Mar 2022 10:50:38 +0100 (CET)
From: gparc@free.fr
To: pgsql-docs@lists.postgresql.org
Message-ID: 
 <2023185982.281851219.1646733038464.JavaMail.root@zimbra15-e2.priv.proxad.net>
In-Reply-To: 
 <1216810578.281812820.1646732222284.JavaMail.root@zimbra15-e2.priv.proxad.net>
Subject: SQL command : ALTER DATABASE OWNER TO
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Originating-IP: [145.242.20.107]
X-Mailer: Zimbra 7.2.0-GA2598 (ZimbraWebClient - FF3.0 (Linux)/7.2.0-GA2598)
X-Authenticated-User: gparc@free.fr
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/2023185982.281851219.1646733038464.JavaMail.root%40zimbra15-e2.priv.proxad.net>
Precedence: bulk


Hello,

for this "ALTER DATABASE" form, it should be mentioned that after execution of the command,
the old database owner loses all his privileges on it (even connection) although it might
still owns schemas or objects (tables, index,...) inside it.

Thanks in advance to add this important precision.

Regards
Gilles