Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tioFu-002Y8n-7g for pgsql-admin@arkaria.postgresql.org; Fri, 14 Feb 2025 05:28:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tioFr-0038FP-WE for pgsql-admin@arkaria.postgresql.org; Fri, 14 Feb 2025 05:28:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tioFr-0038FE-Kx for pgsql-admin@lists.postgresql.org; Fri, 14 Feb 2025 05:28:48 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tioFp-000kOK-36 for pgsql-admin@lists.postgresql.org; Fri, 14 Feb 2025 05:28:47 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-aaec111762bso359918266b.2 for ; Thu, 13 Feb 2025 21:28:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1739510925; x=1740115725; darn=lists.postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:from:to:cc:subject:date:message-id:reply-to; bh=Z9wf84SA8h58fsgMy7Io8x7clbmkP0XOGD2FIXRCDsk=; b=LzpX+HdgZ+kZ9ONJ24kxjQSh1HMguMhlh1h+9+JCtKAA+McW2gDb4y1XjrSvJMsGVI kaKpJ+D0+wLOvyPkNsN4yzT7PyyNk/Ke9zoF7o4aSAoi1EuaH8SQf9fFTvA0+jd1xXel gizf/g3rwSy3j2GW5BIoY61DkAiZZJCtcA8d23qjnNpgBqkwl6UCFMQR+xv+2a+wBayd l4Q2sXoWik3RAOx3fDhhpW7mhWIKIklDaVqO8g1NJibsqdgtNor9y4iW7e2CEw3p+nFb DhuV/1dJdmKhUodsdhALlMx4xu3eu1SJjrw21CxHjF55+SNxFHDUPtpF1q3srnYLIPaW KTjQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739510925; x=1740115725; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Z9wf84SA8h58fsgMy7Io8x7clbmkP0XOGD2FIXRCDsk=; b=ZhY9meYvyn5tMurAS5vUwthG3EiN16Ji1modRlJRcccQLbdB4Y49AeXZ85Ez57AZrt qxjKW1O4LinaGKGqXj8MQnZ+IXhD+zWXFIKn5/jaeq0VCsK+IxbEln5zEIcaYTvOW/9I 6c5dBlazViCheF+hxtlPjk/TgkLt54cQulCQe158rVwKLivEBayxpcKLOcdnbeq2IDdr PZiHFDdYX6564FCo+CUo4eACVNI62kWC8arOLz893G3UOKT6oicuq17m/jAVn4/su4Gp HvFZCuCMPiegPm2zmAPjvYSVhpMonpA8KA2z5UdijSK2XF3aSynKlIX/EtgqUxh8AvH1 KVCQ== X-Forwarded-Encrypted: i=1; AJvYcCV1tipIk/8qRbGcMBNvmOnnU/hRRykCxlzyeqtZ2fmweRzdbuAboAv8HqALD7GHJOkocDhfnASES/j9kQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YyfKQ4jCj7KL+s8ybCpm2yMBm2hELsKr5V+E9PqpDu33Lf8qhaO kT7q7tcPgB+K8vE4QHsiYOmxiSwecanAjGnMRXlyGHjMqIn7bhK5S+KSFzTTkbd0oyB5z6t7dLK uUdPa4UJ5n3EP7R3ZEYIr22hF5SkOgA2saUtd4iVuKE+CtU/a4oo5pRHVCxXhew== X-Gm-Gg: ASbGncta0xB4EWQ/3LFRDK+WY3gW66CJ/lvhvQyKxQaiVs+Ow24UcYtO6JD4MdoImmf h819kK4/Oc4hVu8Oqw+XnNBnxyk7V3QjPkkngnUEWN1B+Kws0caE7FVQk2pasjD3v1mbf+HFSiL B4pmxKBsO1wmFc8orecPki+iW9YC5t0dGOScqT+2wdBlm8MIcg6l3CX0TnUtGMc4i5m8HukVPvZ RqLSDpjEjgZYynb/kAvovK8gvSQrFwEwrhkqG+gDDnN5lxi+p+jYflpXUxzkytMEztOkQTr2wXO 9eTxJs64eRsj3NO8agDMCkYqRQUKXl23a8Ip X-Google-Smtp-Source: AGHT+IGdGpfNhsM3PdyuWQr39XPX8MfmxrA74iULLgKapdWSUk19q+SzOGiaPqpbtTik4Twz/CwZQg== X-Received: by 2002:a17:906:ee87:b0:ab6:d59b:614d with SMTP id a640c23a62f3a-ab7f33814aemr1040944566b.23.1739510924612; Thu, 13 Feb 2025 21:28:44 -0800 (PST) Received: from localhost.localdomain ([2001:871:255:52d3:3ac8:61ab:b634:342]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-aba532552a2sm268112866b.52.2025.02.13.21.28.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Feb 2025 21:28:44 -0800 (PST) Message-ID: Subject: Re: Extensions and schema From: Laurenz Albe To: Edwin UY , pgsql-admin@lists.postgresql.org Date: Fri, 14 Feb 2025 06:28:43 +0100 In-Reply-To: References: User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-02-14 at 17:43 +1300, Edwin UY wrote: > Just curious, does the Schema 'owner' matter unde \dx ? Or is it decided during > the CREATE EXTENSION in the background depending on the extension? The schema must already exist when you create an extension in it, and CREATE EXTENSION does not affect the ownership or permissions on the schema. Yours, Laurenz Albe -- *E-Mail Disclaimer* Der Inhalt dieser E-Mail ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte, dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen. *CONFIDENTIALITY NOTICE & DISCLAIMER *This message and any attachment are confidential and may be privileged or otherwise protected from disclosure and solely for the use of the person(s) or entity to whom it is intended. If you have received this message in error and are not the intended recipient, please notify the sender immediately and delete this message and any attachment from your system. If you are not the intended recipient, be advised that any use of this message is prohibited and may be unlawful, and you must not copy this message or attachment or disclose the contents to any other person.