Yeah, that's still on my should-fix-for-7.5 list (and I think Fabien was going to, or already did, submit some ACL-hacking code to help). That is, ALTER OWNER should adjust the ACL so that grants made by/to the former owner now appear to be by/to the new owner.
However, there's still the problem that a dump from a 7.4 or older database might exhibit the inconsistent ACL entries. Not very sure how to cope ...
How about "if the grant is to user blah, from user blah and blah is not the owner of the object, grant as default user, not user blah"?
Chris
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
