Re: BUG #1145: silent REVOKE failures - Mailing list pgsql-bugs

From Fabien COELHO
Subject Re: BUG #1145: silent REVOKE failures
Date
Msg-id Pine.LNX.4.58.0406091733460.23525@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: BUG #1145: silent REVOKE failures  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #1145: silent REVOKE failures
List pgsql-bugs
> >> For the TODO, I would suggest something general:
> >> - fix grant/revoke wrt SQL standard, validate errors, warnings and successes.
>
> > Tom, is this done?
>
> I think so.  At least, we're a lot closer to spec than we were.

Indeed.

Maybe the validation part could be improved somehow, with test cases
build from the sql specification and the expected behavior checked
against the actual behavior.

What I derived from the many discussion and time I spent on the standard
is that there is a lot of subtlety involved.

So maybe the following TODO could be kept:

 - validate grant/revoke (error, warning, success0 wrt sql standard

I may be interested in implementing ROLEs someday, and such tests would be
welcome just to check that nothing is broken.

--
Fabien Coelho - coelho@cri.ensmp.fr

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1145: silent REVOKE failures
Next
From: "Jie Liang"
Date:
Subject: Re: [ADMIN] out of memory error