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