| From: | Rod Taylor <rbt(at)rbt(dot)ca> | 
|---|---|
| To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | pg_dump and REVOKE on function | 
| Date: | 2003-08-12 15:28:50 | 
| Message-ID: | 1060702128.83667.24.camel@jester | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sla-net | 2003-08-12 15:58:23 | concatenation = = transaction ????? | 
| Previous Message | Stephan Szabo | 2003-08-12 15:25:31 | Re: Oversight? |