Re: How to made available for a database an already installed language on another database ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to made available for a database an already installed language on another database ?
Date
Msg-id 16828.979744102@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to made available for a database an already installed language on another database ?  (Richard Bayet <bayet@enseirb.fr>)
List pgsql-admin
Richard Bayet <bayet@enseirb.fr> writes:
> Thanks a lot Tom, that do solves the first part of my problem...
> Has anyone an idea about the second part, that is, one the
> authentification passed, this error message:
> "$>createlang plpgsql theirdb
> createlang: A function named 'plpgsql_call_handler' already exists.
> Installation aborted." ?

Sounds like you had previously let createlang get as far as creating the
handler function but not as far as making the pg_language entry.  Just
drop the function and try again --- or read the createlang script and do
the same couple of commands manually, it's not *that* hard ;-)

            regards, tom lane

pgsql-admin by date:

Previous
From: Richard Bayet
Date:
Subject: Re: How to made available for a database an already installed language on another database ?
Next
From: Markus Wigge
Date:
Subject: Database Privileges