Re: [GENERAL] restore error - language "plperlu" is not trusted - Mailing list pgsql-patches

From Tom Lane
Subject Re: [GENERAL] restore error - language "plperlu" is not trusted
Date
Msg-id 24133.1071780343@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] restore error - language "plperlu" is not trusted  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: [GENERAL] restore error - language "plperlu" is not trusted  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
Peter Eisentraut <peter_e@gmx.net> writes:
> Attached is my proposed patch for this problem, to be put in 7.4.1.
> Please someone give it a quick check.

The aclchk change looks okay if that's the behavior you want, but I
wonder why you don't just make it raise error in both the GRANT and
REVOKE cases.

The pg_dump change looks okay for the 7.4 branch.  It will not apply to
HEAD but I think you can just add

    if (plang->lanpltrusted)

before the dumpACL call in that case.

            regards, tom lane

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] restore error - language "plperlu" is not trusted
Next
From: Karel Zak
Date:
Subject: Re: ISO year.