Martin Renters <martin@datafax.com> writes:
> Isn't it possible for PostgreSQL to delete permissions on tables when a
> user gets deleted?
Not as long as users span multiple databases. The deleting backend
can't even get to the other databases in which the user might have
permissions.
regards, tom lane
