Re: mistakes in postgresql-snapshots (7.3)

Should we provide a script that goes through the dump file and spits out
the GRANT's they are going to need to perform?  They can them pipe that
into psql.

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Oh, so createlang is fine, it is CREATE LANGUAGE that doesn't have the
> > GRANT, but that makes sense.  The problem is that 7.2.X pg_dump doesn't
> > add the GRANT to the load script because we didn't have such permissions
> > in 7.2.X.
>
> Right.  Not only CREATE LANGUAGE, but CREATE FUNCTION, and for that
> matter CREATE DATABASE, are going to have some issues of this sort
> for people loading old dumps.
>
> > Wonder how we are going to fix that?
>
> I think we're gonna tell 'em to issue some manual GRANTs.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026