Re: [HACKERS] pg_dump is broken by recent privileges changes

2003-02-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> REVOKE ALL ON SCHEMA public FROM PUBLIC; >> >> which fails with >> >> ERROR: dependent privileges exist (use CASCADE to revoke them too) > Not here. [ scratches head ] Not here either; but it was definitely failing when I wrot

Re: [HACKERS] pg_dump is broken by recent privileges changes

2003-02-10 Thread Peter Eisentraut
Tom Lane writes: > REVOKE ALL ON SCHEMA public FROM PUBLIC; > > which fails with > > ERROR: dependent privileges exist (use CASCADE to revoke them too) Not here. > This message seems incorrect --- what is a dependent privilege, and > why would PUBLIC have any? The term "dependent privilege" is