Re: BUG #1145: silent REVOKE failures

Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> For the TODO, I would suggest something general:
> - fix grant/revoke wrt SQL standard, validate errors, warnings and successes.

I have a patch-in-progress that addresses these issues. I didn't get it
quite finished before leaving for vacation, but hope to clean it up and
commit soon. There was an open issue, which was whether we want the
owner's grant options to be shown in the default ACL value or not.
(This would be only cosmetic and not functional, because the code will
treat the owner as having grant options in any case.) A related
question is whether the information_schema display of grant options
should track what the ACL says or tell the truth, namely that the owner
has grant options regardless. (Doing the latter would force changing
the API of aclcontains(), hence initdb.)

I asked for opinions on this but got little feedback.

regards, tom lane