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 1uSGei-005TSy-4l for pgsql-general@arkaria.postgresql.org; Thu, 19 Jun 2025 14:54:20 +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 1uSGeg-00C6J4-2a for pgsql-general@arkaria.postgresql.org; Thu, 19 Jun 2025 14:54:18 +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 1uSGef-00C6Iw-OQ for pgsql-general@lists.postgresql.org; Thu, 19 Jun 2025 14:54:18 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uSGee-002xqK-0h for pgsql-general@lists.postgresql.org; Thu, 19 Jun 2025 14:54:18 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-72bd5f25ea6so275754a34.1 for ; Thu, 19 Jun 2025 07:54:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750344855; x=1750949655; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=WDFeB96eT8ZTnm/i161q5p0fpILp1Ope83VThHs7e7k=; b=InO2ynCpxwnMRvYKUxp/XFA0ggB5YhmhSemysLYY1PlC8OfhjH9crlyh+O3JtDyCMP PaEC5px0t8DSxyKsok/26830qCagU5g7n4TxZivA6eJ6rfLhLSSEpXTn57pJyN/VcRwm C+u2uUFWdIbHZ7q53u/2Tq9M7YnjH/88WcKki/oKmNqVqPJTjm8p8FR5khvgbG9r3RMw njR5yCEBld4QgrIqdXvgRRr8hGQV5qJ2llhAQCIFuasLKVYOoIejhe8ujrE3k9Bh1CYP 7qJsUef/vAlS3FJzO+tAA9TvZ45C9fM2Oy+BCBW1rB/5tLraGK5DFdULwbPFuYWWK3rY JJdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750344855; x=1750949655; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=WDFeB96eT8ZTnm/i161q5p0fpILp1Ope83VThHs7e7k=; b=q72AjfCWnFKmzUzdcHENOYNoCpmfBWpfvaRuMDz0iSkZXqYEFvN04y/IXFurdPmXEo 3Yc3ddHTC5n/ZVnCQ3WTxi6hWGoDsH7Q9ceDUWx9VB3fppQhDzlDqJpAila/ZzM7jozH mrj3tURDqpWkc0/qtyh6T/vPNRh5NixDzv39StAv5bqBEpMDNqJhPuIaV6f2ogt33r2P r/uGrFZTvsTYJxUl+PWOH6wpq2oF8u5JOKJYK5UUheN7Js9zTejnkRCHXPP+bgJl/9i/ Sdtx3ircZEf6BPLeaCU7lyeBy5TW5eBLpwHZn4o0k8F2jk0lI7krNvmHPCld2G/n/rXi OT6A== X-Gm-Message-State: AOJu0Yx5FptLN6uNUJCBJnW4UvuC4dA98W6UeIT8JZzSHTWRMfnrqFXT bIP2Fr1Mmu7FRpXY/YgIInwwM67/KSm2FO3KoHhILlLvuN/PgHPtZryz/Zta37MnONQ/xY6Qx1H iWW1++HYmy7JO0ZN3DjeFGG/ngTChxrP6Htrq X-Gm-Gg: ASbGncsWPLBGpbwFbawXX38lNt4lghhKuJh6+nelDwjXku+4iCUkKfiqVEXGRvWKAsl lHTu5V8M/tDLlEfT0xD6pi54cCHCDCu/GBlPzvehl7Anpde61H8wOcIjuTA6dxK5GfzEsPI00gN K5GLHhvf2hqCjhYj6d4cj/8nNnYk45VDN1hfqElzotLjqfvg== X-Google-Smtp-Source: AGHT+IGj1P11k4dYh5Aewp7eiP2zeSE9MSsGo0ThA1q9p/ymgeK8p5AQJ/IGFAWbYjeSd+xZnIjl4Gzr7l82p1Xcg/I= X-Received: by 2002:a05:6870:568c:b0:2d5:c61f:c2db with SMTP id 586e51a60fabf-2eaf0ba304dmr13716830fac.34.1750344854639; Thu, 19 Jun 2025 07:54:14 -0700 (PDT) MIME-Version: 1.0 References: <002c519f-fb22-4ec0-b3e3-719f1d54035e@aklaver.com> In-Reply-To: <002c519f-fb22-4ec0-b3e3-719f1d54035e@aklaver.com> From: Dominique Devienne Date: Thu, 19 Jun 2025 16:54:03 +0200 X-Gm-Features: Ac12FXwDBxb5LASPwetcDzcesotbvH4vginXfbJEzMKyuDw5QvZgQ92mVDYTsKw Message-ID: Subject: Re: Extension disappearing act To: Adrian Klaver Cc: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 19, 2025 at 4:18=E2=80=AFPM Adrian Klaver wrote: > On 6/19/25 06:09, Dominique Devienne wrote: > > Hi. Little mystery we don't understand. v17. > Does 'all' include the public schema? No. We don't touch `public` at all, beside pgcrypto ending up inside it. > > Of course, the DB owner role was not dropped. Can't in fact. > > Somehow, the pgcrypto extension has disappeared, as side-effects of the= drops. > > Was it in fact installed in the public schema? Sure was. It's my own command, but good enough. --DD D:\>ppg -c my17 -d dd_v168a database_ --extensions Connected OK (postgresql://ddevienne@localhost:5417/dd_v168a) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D | Name | Version | Owner | Schema | =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D | pgcrypto | 1.3 | "Acme-DBA:000ik2" | public | | plpgsql | 1.0 | postgres | pg_catalog | =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D 2 installed extensions (out of 61) Which runs SELECT extname, extversion, extowner::regrole::text as owner, extnamespace::regnamespace::text as "schema" FROM pg_extension ORDER BY 1