agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: shihao zhong <zhong950419@gmail.com>
Cc: imchifan@163.com, Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
Date: Sun, 20 Sep 2026 15:18:33 -0400
Message-ID: <546233.1789931913@sss.pgh.pa.us> (raw)
In-Reply-To: <CAGRkXqTssJ5ttoY_BATULMChBHQAAyO3sPNBMXGnCOws3ANRQQ@mail.gmail.com>
References: <19703-49d6f1796001a6d7@postgresql.org>
<362684.1789919385@sss.pgh.pa.us>
<CAGRkXqTssJ5ttoY_BATULMChBHQAAyO3sPNBMXGnCOws3ANRQQ@mail.gmail.com>
shihao zhong <zhong950419@gmail.com> writes:
> This may needs a catversion bump and backport to 14.
> The older version requires manual drop and recreate the view.
In principle we don't need a catversion bump here, since there's
no C-code-versus-catalogs compatibility issue. But we have usually
done one for information_schema changes.
I think I'd vote against back-patching. The fact that this went
unnoticed for 14 years demonstrates what low impact it has.
I don't foresee people wanting to manually replace that view in
order to fix it in existing installations.
regards, tom lane
view thread (5+ messages) latest in thread
Message-ID: <546233.1789931913@sss.pgh.pa.us>
Permalink: ../546233.1789931913@sss.pgh.pa.us/
Also on: postgresql.org/message-id/546233.1789931913@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, zhong950419@gmail.com, peter@eisentraut.org, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
In-Reply-To: <546233.1789931913@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox