Tom Lane writes:
> nothing happens, because the revoke is implicitly assumed to mean
> "revoke whatever privileges I granted", and Larry's superuser hasn't
> granted any. The public privileges on language SQL were granted by
> user postgres, and they remain in force. So the later CREATE FUNCTION
> that the test expects to fail, succeeds.
>
> Is this a bug, or is it correct-per-spec behavior?
It's correct.
--
Peter Eisentraut [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
