Re: mistakes in postgresql-snapshots (7.3)

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073