Peter Eisentraut wrote:
> Tom Lane writes:
>
> > pg_dumpall doesn't yet do the right thing at the database level, but I
> > believe he's planning to take care of that.
>
> I have never heard of database privileges, except that people occasionally
> expect me to fix something about them. :-/
>
> > I'm not sure there is anything we can do about this without making
> > life worse. But it's annoying. Any thoughts?
>
> There are a couple of simple recipes we can give to users, such as
>
> UPDATE pg_language SET lanacl = '{"=U"}' WHERE lanpltrusted;
> UPDATE pg_proc SET proacl = '{"=X"}' WHERE proacl IS NULL;
>
> The trick is that you'd need to run the first line before creating any
> functions. Blech.
OK, I have removed this open item:
Fix db, function, language permissions on 7.2 database loads
and added this documentation item:
Document need to add permissions to loaded functions and
languages
Current open items page is at:
ftp://candle.pha.pa.us/pub/postgresql/open_items.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073