> 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