Re: pg_dump and REVOKE on function
От | Peter Eisentraut |
---|---|
Тема | Re: pg_dump and REVOKE on function |
Дата | |
Msg-id | Pine.LNX.4.44.0310052348220.2745-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: pg_dump and REVOKE on function (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers |
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 is output from 7.3 pg_dump that is being loaded into 7.4 beta1. > > > > It would seem that revoking the permissions of the owner doesn't work > > out so well. > > > > > > r=# CREATE FUNCTION weekdate (date) RETURNS timestamp with time zone > > r-# AS ' > > r'# SELECT cast(to_date(''01 01 ''|| extract(''year'' FROM $1), ''DD MM > > YYYY'') + > > r'# (cast(extract(''week'' FROM $1) AS numeric) *7-8) * interval ''1 > > day'' as timestamp with time zone);' > > r-# LANGUAGE sql; > > CREATE FUNCTION > > r=# > > r=# > > r=# -- > > r=# -- TOC entry 752 (OID 18968885) > > r=# -- Name: weekdate (date); Type: ACL; Schema: public; Owner: rbt > > r=# -- > > r=# > > 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 too. > > > -- End of PGP section, PGP failed! > > -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-hackers по дате отправления: