Tom Lane wrote: > 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.
Yep, that is it. It was reported as a bug by two people recently. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
