Re: mistakes in postgresql-snapshots (7.3) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: mistakes in postgresql-snapshots (7.3)
Date
Msg-id 14427.1028582564@sss.pgh.pa.us
Whole thread Raw
In response to Re: mistakes in postgresql-snapshots (7.3)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: mistakes in postgresql-snapshots (7.3)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: mistakes in postgresql-snapshots (7.3)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: mistakes in postgresql-snapshots (7.3)
Next
From: Tatsuo Ishii
Date:
Subject: Re: mistakes in postgresql-snapshots (7.3)