Re: mistakes in postgresql-snapshots (7.3)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: mistakes in postgresql-snapshots (7.3)
Date: 2002-08-05 20:53:20
Message-ID: 200208052053.g75KrKG16229@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Wonder how we are going to fix that?

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

Pavel Stehule wrote:
> Hello
>
> I'm sorry. I have not a true, I didn't use plain database. I started with
> removing detabase, creating new template, but I loaded oldest database,
> which I dumped before .
>
> on 7.2.1 pg_dumpall > old
> on 7.3 psql -f old template1
>
> This steps created language with bad privilegies. On truely "virgin"
> template1 language works fine.
>
> Thank you
> Pavel Stehule
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-08-05 21:22:44 Re: mistakes in postgresql-snapshots (7.3)
Previous Message Pavel Stehule 2002-08-05 20:12:53 Re: mistakes in postgresql-snapshots (7.3)