Rod Taylor <[EMAIL PROTECTED]> writes: >>> ERROR: dependent privileges exist (use CASCADE to revoke them too) >> >> I saw that a couple weeks ago, and then was unable to reproduce it later
> Seems to be by design. Create an empty schema with no permissions. > First REVOKE sees lack of permissions, and adds them for the owner. The > GRANT makes PUBLIC dependent on the owner for permissions. The second > REVOKE attempts to remove the permissions of the owner (replace > CURRENT_USER with the current user) which PUBLIC is now dependent upon. Hmm. So the real story here is that the permissions set up by initdb for PUBLIC are actually an illegal state: postgres has granted permissions to public that it isn't allowed to. When pg_dump tries to reproduce that state, it can't. (There may also be an issue with the order in which pg_dump issues its revoke/grant operations, ie, there might be legal combinations that it can't reproduce.) Peter, what do you think? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster