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@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