Message-ID: <71eb9a8835a28165939da567a9d649fe6d21bfa7.camel@j-davis.com>
Subject: Re: Avoid orphaned objects dependencies, take 3
From: Jeff Davis <pgsql@j-davis.com>
To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, Robert Haas
 <robertmhaas@gmail.com>,  Roman Eskin <r.eskin@arenadata.io>, Michael
 Paquier <michael@paquier.xyz>, Alexander Lakhin <exclusion@gmail.com>,
 pgsql-hackers@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Date: Mon, 08 Jun 2026 14:55:19 -0700
In-Reply-To: <aiLKkTC6QBt8i35P@bdtpg>
References: <9f5f0dd4-96d5-4d90-9436-62d96e0298f9@arenadata.io>
	 <ad/awXLnMuc6Rf5M@bdtpg> <afCXPVNuvpf5ECGZ@bdtpg>
	 <CA+TgmobtzkG9HzGtDXbgb3KVE46qHuSvGcuKHgAGQ1aejCoLLw@mail.gmail.com>
	 <agsCqlLTytZCudMv@bdtpg> <aebf583b-b904-4035-a1c1-a4c5ad064dec@iki.fi>
	 <ahYAKgbx05IQdjwR@bdtpg> <3963e573-4852-4d25-b741-7c5c7e1f9140@iki.fi>
	 <ah1PIyqtT+427dWb@bdtpg>
	 <02e28438bd448ff4ee8f6fd78e6b74e657172d73.camel@j-davis.com>
	 <aiLKkTC6QBt8i35P@bdtpg>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3-0ubuntu1.1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/71eb9a8835a28165939da567a9d649fe6d21bfa7.camel%40j-davis.com>
Precedence: bulk

On Fri, 2026-06-05 at 13:09 +0000, Bertrand Drouvot wrote:
> the current patch

  /*
   * Look up a tracked aclcheck entry for the given object.
   * Returns true if found, filling in roleId, mode, and inval_count.
   * Searches from the end to find the most recent check (the one with
the
   * freshest inval_count).

What if two tracked ACL checks had different modes? Don't you need to
do both checks or somehow combine the modes in the tracking entry?

(I'm not sure if this is a practical problem or not.)

Regards,
	Jeff Davis