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

On Wed, 2003-12-17 at 10:55, scott.marlowe wrote:
> > which performed everything as expected with the following ERROR
> > message:
> >
> > ERROR: language "plperlu" is not trusted
> >
> > and it gave a line number, which contained the following:
> >
> > GRANT ALL ON LANGUAGE plperlu TO postgres WITH GRANT OPTION;
> >
> > Now, my plperlu functions seem to behaving as expected (they read from
> > and write to /tmp). Should I be worried?
>
> Did you install plperlu ahead of time as the super user, then run your
> restore as the regular database owner?

No, I hadn't, I guess I had assumed that the restore would do that.
More interestingly, I did the restore on a different
machine/architecture (PPC instead of Intel) running 7.4 final release
(instead of RC2) and I didn't get the error message. However all of my
plperlu triggers seem to behaving normally. When I tried to install
plperlu afterwards I got this:

createlang plperlu a
createlang: language "plperlu" is already installed in database "a"

Hrm... Ah well. I'll know for next time to install the language first,
I just hope it won't bit me in the ass before then. :-)

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax: (514) 398-2017