Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot create perlplu function - Mailing list pgsql-novice

From Thangalin
Subject Re: Cannot create perlplu function
Date
Msg-id CAANrE7pM=Ocn_WbmQLo1rrJaKV992PEhND_S4MWCP0K376hjag@mail.gmail.com
Whole thread Raw
In response to Re: Cannot create perlplu function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
Hi,

Resolved as follows:

DROP LANGUAGE plperl;
DROP LANGUAGE plperlu;
CREATE OR REPLACE TRUSTED LANGUAGE plperlu;
UPDATE pg_language set lanpltrusted = true where lanname='plperlu';
GRANT ALL ON LANGUAGE plperlu TO account_name WITH GRANT OPTION;
ALTER USER account_name WITH SUPERUSER;
Don't know what happened, but removing "plperl" and adding the account as a SUPERUSER helped resolve it.

Thank you.

pgsql-novice by date:

Previous
From: Bastiaan Olij
Date:
Subject: Re: about .pgpass
Next
From: Kevin Grittner
Date:
Subject: Re: Implementing SCD Type 2.