Re: restore error - language "plperlu" is not trusted - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: restore error - language "plperlu" is not trusted
Date
Msg-id 200312181838.18894.peter_e@gmx.net
Whole thread Raw
In response to Re: restore error - language "plperlu" is not trusted  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: restore error - language "plperlu" is not trusted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Uh, no, because you can say something like
>     revoke all on language plperlu from public;
> and end up with non-null lanacl (because it instantiates the default
> assumption that the owner has all privileges).

OK, that needs to be disallowed.

> We could possibly hack the backend to avoid that, but I think pg_dump
> will need the special-case test anyway since it has to be able to
> cope with existing databases, wherein lanacl may be non-null.

So far we know of 1 such database.  I'd like to see some more before we
bother about it.


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Function Returning SETOF Problem
Next
From: Tom Lane
Date:
Subject: Re: restore error - language "plperlu" is not trusted