Re: [HACKERS] pg_dump and REVOKE on function

2003-10-05 Thread Peter Eisentraut
Fixed. Bruce Momjian writes: > > This item has been added to the 7.4 open items list: > > ftp://momjian.postgresql.org/pub/postgresql/open_items > > --- > > Rod Taylor wrote: > -- Start of PGP signed section. > > Below

Re: [HACKERS] pg_dump and REVOKE on function

2003-09-26 Thread Bruce Momjian
This item has been added to the 7.4 open items list: ftp://momjian.postgresql.org/pub/postgresql/open_items --- Rod Taylor wrote: -- Start of PGP signed section. > Below is output from 7.3 pg_dump that is being load

Re: [HACKERS] pg_dump and REVOKE on function

2003-09-01 Thread Peter Eisentraut
Tom Lane writes: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Given that rbt is the owner of the object, I'm not sure that it is > >> sensible to interpret the above as revoking his ability to grant > >> privileges to others. > >> > >> Peter, any thoughts? > > > Has this be

Re: [HACKERS] pg_dump and REVOKE on function

2003-08-31 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Given that rbt is the owner of the object, I'm not sure that it is >> sensible to interpret the above as revoking his ability to grant >> privileges to others. >> >> Peter, any thoughts? > Has this been resolved? No. I was hoping Pet

Re: [HACKERS] pg_dump and REVOKE on function

2003-08-31 Thread Bruce Momjian
Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM PUBLIC; > > REVOKE > > r=# GRANT ALL ON FUNCTION weekdate (date) TO PUBLIC; > > GRANT > > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM rbt; > > ERROR: dependent privileges exist > > HINT

Re: [HACKERS] pg_dump and REVOKE on function

2003-08-14 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM PUBLIC; > REVOKE > r=# GRANT ALL ON FUNCTION weekdate (date) TO PUBLIC; > GRANT > r=# REVOKE ALL ON FUNCTION weekdate (date) FROM rbt; > ERROR: dependent privileges exist > HINT: Use CASCADE to revoke them to