Re: restore error - language "plperlu" is not trusted

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca>, postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: restore error - language "plperlu" is not trusted
Date: 2003-12-18 17:38:18
Message-ID: 200312181838.18894.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-18 17:49:49 Re: restore error - language "plperlu" is not trusted
Previous Message Joe Conway 2003-12-18 17:07:34 Re: Function Returning SETOF Problem

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-18 17:47:41 Re: ISO year.
Previous Message Peter Eisentraut 2003-12-18 17:28:20 Re: replace all with * in pg_hba.conf