Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
Date
Msg-id 546233.1789931913@sss.pgh.pa.us
Whole thread
In response to Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege  (shihao zhong <zhong950419@gmail.com>)
Responses Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: shihao zhong
Date:
Subject: Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege
Next
From: shihao zhong
Date:
Subject: Re: BUG #19703: information_schema.usage_privileges omits a sequence owner's implicit USAGE privilege