Re: How to made available for a database an already installed language on another database ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Bayet <bayet(at)enseirb(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to made available for a database an already installed language on another database ?
Date: 2001-01-17 15:08:22
Message-ID: 16828.979744102@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Richard Bayet <bayet(at)enseirb(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Wigge 2001-01-17 15:27:54 Database Privileges
Previous Message Richard Bayet 2001-01-17 11:49:01 Re: How to made available for a database an already installed language on another database ?