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.96) (envelope-from ) id 1vO3Vj-007uuR-1o for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 00:35:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vO3Vi-00Cyb7-0I for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 00:35:54 +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.96) (envelope-from ) id 1vO3Vh-00Cyay-2M for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 00:35:54 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vO3Vf-001VzW-2n for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 00:35:53 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-789314f0920so54499207b3.1 for ; Tue, 25 Nov 2025 16:35:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764117348; x=1764722148; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=1fL+gKrNB3SMuu5xNqxqUdJB7jmiAuQxjHFfx5z4UHw=; b=GK0BXzzmYLo/wJaevHQfHM1iCs4CU/bLa0TZLO5x3i5Pbi/2YgIXE9nleUcRCv4oKH MjDIz712D5um3JlvjnfQ1jhDQeNEQrt0fueic+0MQQWAx2f6zmngTfXIqqEwGFicPy7R kpXG+rHXXkLrTyggdfqiPloyF2xNXLF3MD7YAC/4uIjxg/QoFNiIuX36YfFgR85tdKMB WQyFr1ieMyOjgL5xIufU+p0Hf7dYzelVWWTcpSeNaVCCuTzyCScaqJiUzMElMCzVgcvd smgtsV/dAyD4tVuJmmzI3eRF8kLs+XotT6EVHD9gJXe53dRapCvi4n4uVV2Haiq4Sm4A 5JiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764117348; x=1764722148; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=1fL+gKrNB3SMuu5xNqxqUdJB7jmiAuQxjHFfx5z4UHw=; b=eIixJthFwGsARMzUJe/Y2o/bRRbkI2S+vWe+zBwVINu+RZZySL2b5LFP+iqDcyLdAf T9kZhB5CrHLwune1sFU5IFv3RpifWKVrHR6/QDhxSS6AVSFw4arMfSm7wxHDjNzw+mYB E5ajLiSahc8BKx4ruyeCJY/2jvrJs2hk6Xleom4/wAh19aJWHmAMuJZQialjvw8PduGS tRetk0MU//KJnMvdw4/1nJJqq994pVkriyHo4JyWWcqcMRYZpSWxXLh9en84EhCL/AIP EXsKzNI0HHYSOw3BI28C27im+3GMi/Ukw95xhiq7HmeADIKnGIniupt3ZVkZARCYe91v zW/A== X-Forwarded-Encrypted: i=1; AJvYcCUW+7Zl70c2bxN6YA7cl2BvF0N7WdgZDnH1G37NgbwDqzOYmqd3TYGlU4pNzFZAwTrIr4KgKUnvgf7TgnRX@lists.postgresql.org X-Gm-Message-State: AOJu0YxFV0YklLWEq0L4kj1wZ1n4PKuVLu0X+w356cXsNRTJYgAFEXZz arM6gWlimRGEK+ykRUOmZrCln4t4HYrhAVfS/Akdm3vp7t5VqNWyStcxOAywk8hmWzaWqtVD/Ne VRpAT2chCBa6Bxst73tkD0Lv10Aew2ys= X-Gm-Gg: ASbGnctHISeqSqtSFXjh4QVTlXzcIw3rSc8TEbClZtrH7oVrtYvOPIzP79gNtiKNvDt DspGnnc+VxbAjBIyMUUHXcml96ITatxGAfMgM0wy5JHuqYZB1WrbRZhBWlBdmm2EIqdzMA0qCIf r9HOvU92Oi2UKlxdSfeuPjFuP8cvBz4DAZWsDO/Xw8D6FtbqCKWhJvfccRoYmUpNU7Ryx2Ln2M0 fmku52NxkiMEJQwBvkC0lDV+TYnL2fUH3lSAQy+qTHZZtLH8i9DvlUanIOelrkVj0QS9Cnr X-Google-Smtp-Source: AGHT+IGeiMRh7KyohNjzuUnTKvsl+qirX5M5kXLFA6Fs/tvalzxA38+WtfZGo+afqx2IecPB9KJ4ddeh3sJdP8W1uFc= X-Received: by 2002:a05:690c:e3e5:b0:786:9774:a3d2 with SMTP id 00721157ae682-78ab6fd6100mr37490417b3.69.1764117348271; Tue, 25 Nov 2025 16:35:48 -0800 (PST) MIME-Version: 1.0 References: <1484313.1764115685@sss.pgh.pa.us> In-Reply-To: From: immerrr again Date: Wed, 26 Nov 2025 01:35:37 +0100 X-Gm-Features: AWmQ_bnrBZLDtd8-t8bDpXO9H_6k4uCvtvbZVDF9hJXcLsAmGRDCiRJVi0S0uf0 Message-ID: Subject: Re: DROP ROLE blocked by pg_init_privs To: Tom Lane Cc: Pavel Luzanov , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e2c89b06447493a3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e2c89b06447493a3 Content-Type: text/plain; charset="UTF-8" > I have written a couple of queries to manually clean up the system tables pg_init_privs/pg_shdepends instead (see [1]) Sorry, wrong link [1]. Should have been 1. https://www.postgresql.org/message-id/CAERznn-QWVpAvqnyF%3DrZfiuxkeDG0tym_rY%2BRuEkSPWvzgi67Q%40mail.gmail.com > --000000000000e2c89b06447493a3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

> I have wr= itten a couple of queries to manually clean up the system tables pg_init_pr= ivs/pg_shdepends instead (see [1])

--000000000000e2c89b06447493a3--