Re: Include RELKIND_TOASTVALUE in get_relkind_objtype
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael@paquier.xyz>
Cc: "Hsu, John" <hsuchen@amazon.com>,
"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>,
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Date: 2019-11-04T20:31:27Z
Lists: pgsql-hackers
Attachments
- toast-acl-errors-2.patch (text/x-diff) patch
Michael Paquier <michael@paquier.xyz> writes: > Okay. Attached is what I was thinking about, with extra regression > tests to cover the ground for toast tables and indexes that are able > to reproduce the original failure, and more comments for the routines > as they should be used only for ACL error messages. I'd rather do something like the attached, which makes it more of an explicit goal that we won't fail on bad input. (As written, we'd only fail on bad classId, which is a case that really shouldn't happen.) Tests are the same as yours, but I revised the commentary and got rid of the elog-for-bad-relkind. I also made some cosmetic changes in commands/alter.c, so as to (1) make it clear by inspection that those calls are only used to feed aclcheck_error, and (2) avoid uselessly computing a value that we won't need in normal non-error cases. regards, tom lane
Commits
-
Fix "unexpected relkind" error when denying permissions on toast tables.
- a30531c5c8a3 13.0 landed
- 791864193636 12.1 landed
- 2bfe015b5626 11.6 landed