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 [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])