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 1uMrCJ-005Xr2-Pr for pgsql-general@arkaria.postgresql.org; Wed, 04 Jun 2025 16:42:39 +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 1uMrCH-00EWZb-St for pgsql-general@arkaria.postgresql.org; Wed, 04 Jun 2025 16:42:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uMrCH-00EWZT-Iq for pgsql-general@lists.postgresql.org; Wed, 04 Jun 2025 16:42:38 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uMrCG-000CYR-1J for pgsql-general@postgresql.org; Wed, 04 Jun 2025 16:42:37 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-60d5c665fceso37699eaf.1 for ; Wed, 04 Jun 2025 09:42:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749055356; x=1749660156; darn=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=sKpbWd9e4IT4Cw+SqBXmJzxSr5hAIS06JTWPeczFhnY=; b=k8YgPsm4NYCeQ1QD5VjRFNa532cY7yM3QXuy94Bis6Plwi4M+4bTFu9Et2ivlpqIjN 1ZIqk7dzC1I7bRLpM2z+KHhjJqSreB2WnTbyvK5ywfCxS+OpASS9GzNNUPL6KAXK/xAk hQFtWVf8J0cgGiCekQwrgMPUYgKkxrLuvbOtUvUR8sRw802tsqjhup0zGgFSJkni8N9x E+sC+EllCEjzgEMpADHSQ2FxOJvWceR1VCiObADeQhu/Ny1X94MbsWoptEiz4vl704zC 0Hyc174/r9DwVw+XQlXAhGj34pdGsYXEqM9v/L/+jsOWov4DftCbIJvckkzCSmW3uAGf 4jNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749055356; x=1749660156; 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=sKpbWd9e4IT4Cw+SqBXmJzxSr5hAIS06JTWPeczFhnY=; b=ZDrpDzgnvtCoAu+NEWIzpH/BqeKQxRA66Jbm3nn+a/80UTUFycMZLDpNkDh+JLEuyG A2sMWmGIcmAR/K/6xciwbafKVa/2wgW7M21KcKMK3HVnRoPfoXPISpaYMxbeMpom7S+C 1eG6WHeX6wqqOTNdh7HZ5amVgCAPPVx7Xy6MeWKdf7X5wJcDp/Y+w1pKsXVJ/yBDrAOC wDl+jd+y5TMCrMCzBW/sz88XcRxc01lTlpQTVgFzLlZ3rWWEDzWTQJE0WP891MJWHPgn E5F36/TKE6qQpF40X9HCoRtgul+hUysNqpKvWnwNpaGrB1l7/71029yFDTWku7+uSBz3 ZW1A== X-Forwarded-Encrypted: i=1; AJvYcCUTtkjCudn8++o06RKDnuJX0QovTm4nG5pppFDha/v/bCSmmVlKrOk3DG3MBbF5fhk/ze/DZzlo7QekxH4e@postgresql.org X-Gm-Message-State: AOJu0YwvHtj0mgba9u2YWzOgZesMLhaunyOuaC/GtRI+U2Ezje7vtQEC HBerqp5WhcC10BBdOGS3j2ff8z/sM1YvKm3NbelBJYWCmkXDueWcp7EgnOzmzMjvv1e3vZ2rcCH Mqi/8x6eBhj5WS4Oei18S8e9VN2hiAwQ= X-Gm-Gg: ASbGnctKofj417GLcv5RNhU4PdH4ZRwPgItOTWEFWiogkjZVhWM/TuX+mOGO6D3WQys mu3kZV5PXdvKxb5ZJ9SJVBIn7SgzzJJ3KdMbJsQpYgdJkKYcuM79iaE+M0n/QkNtKHllnsU4wI/ 1uhTffgHdzGH81uZdicnWZx7h1hNOWwTbsLKQ= X-Google-Smtp-Source: AGHT+IHftMUDWooKMwZkfgjQFDnJ4egnzXTNiEJr7HNvoATSPiAw70qrIJpWc5T+zCNyEFI09zWNU5G+ALz49GY4VO8= X-Received: by 2002:a05:6820:1888:b0:607:8929:4501 with SMTP id 006d021491bc7-60f0c70133bmr2021023eaf.1.1749055355768; Wed, 04 Jun 2025 09:42:35 -0700 (PDT) MIME-Version: 1.0 References: <1026415.1749051290@sss.pgh.pa.us> In-Reply-To: <1026415.1749051290@sss.pgh.pa.us> From: Dominique Devienne Date: Wed, 4 Jun 2025 18:42:24 +0200 X-Gm-Features: AX0GCFuO4mLSh_hpLEA4eOWAXJb0d0tMWEfkdi3qRjzERPSsS6DhypiGk9sJbVo Message-ID: Subject: Re: Yet more ROLE changes in v18 beta1??? To: Tom Lane Cc: Robert Haas , pgsql-general@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 Wed, Jun 4, 2025 at 5:34=E2=80=AFPM Tom Lane wrote: > Dominique Devienne writes: > > In any case, if anyone else knows about changes in this area, I'm inter= ested. > > Digging through the commit log didn't find much, but conceivably > > https://git.postgresql.org/gitweb/?p=3Dpostgresql.git&a=3Dcommitdiff&h=3D= 01463e1cc > Ensure that AFTER triggers run as the instigating user. Thanks Tom. We don't drop ROLEs in trigger (yet, we'll get there). So that particular commit is probably not the reason. Thanks a bunch for looking into it. --DD