Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: imchifan(at)163(dot)com, Peter Eisentraut <peter(at)eisentraut(dot)org>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
Date: 2026-09-20 19:18:33
Message-ID: 546233.1789931913@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

shihao zhong <zhong950419(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message shihao zhong 2026-09-20 19:29:28 Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
Previous Message shihao zhong 2026-09-20 18:33:09 Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege