Daniel Kalchev writes:
> One would normally expect, that when DROP USER someuser is issued, all
> associated data structures will be readjusted, especially ownership and access
> rights.
Perhaps, but the documentation states otherwise.
> There is no way to remove rights of this 'user' 98 using REVOKE etc.
>
> Perhaps full dump/reload will remove the rights, because that user will not be
> found, but restore may fail due to the error conditions.
>
> Any resolution for this?
Recreate the user with the given ID and drop the objects manually.
--
Peter Eisentraut peter_e@gmx.net