"Madeleine Theile" <madeleine.theile@xxxxxxxxxxxxxxxxxx> writes: > After I've dropped one of the superusers that created and thus > owns some of the views and reinstalled it again with a different usesysid So reinstall it with the same usesysid --- that's why the option exists to specify sysid in CREATE USER. There is work in progress that will disallow dropping a user that still owns any objects, but I am unsure if it will be done in time for 8.1. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings