Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > My live 7.3.4 database dumps data like this:
> REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC; > GRANT ALL ON TABLE log_freeprofile TO brett; > GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO "au-php"; > GRANT SELECT ON TABLE log_freeprofile TO GROUP readonly; > REVOKE ALL ON TABLE log_freeprofile FROM auadmin; > Now, loading this into 7.4beta3 gives this error: > ERROR: dependent privileges exist > When executing the REVOKE ALL line. Yeah, this is a known issue. I think Peter was off looking into solutions. It's clearly a "must fix" item. Not sure if Bruce's open-items entry Fix REVOKE ALL ON FUNCTION error when removing owner permissions describes exactly the same problem or something else. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match