Hi everybody.
I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL
Server) and I got the following error when trying to create a function using
the default language plpgsql: language "plpgsql" does not exist
I was not able to find clues on the net to help me to solve this proble
Hum, I feel sorry to have disturbed you with such beginner's question.
I just found out the solution: should create the language entry myself.
Next time I hope to have a more interesting question :-)
Seb.
--
Sébastien BAUDRY - DBA Oracle/MS-SQL & Project Manager
BAUDRY ENGINEERING BT. H-1025 Bud
createlang plpgsql
On Tue, 2 Sep 2003, Sebastien Baudry wrote:
> Hi everybody.
> I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL
> Server) and I got the following error when trying to create a function using
> the default language plpgsql: language "plpgsql" does not e
You have to install the procedural language into each database as such:
1. su - postgres
2. createlang plpgsql [your dbname here]
Sebastien Baudry wrote:
Hi everybody.
I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL
Server) and I got the following error when trying to
uot;Renney Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Admin Postgres" <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 3:12 AM
Subject: Re: [ADMIN] language "plpgsql" does not exist
> You have to install the procedural language i
Renney Thomas wrote:
> You have to install the procedural language into each database as such:
>
> 1. su - postgres
> 2. createlang plpgsql [your dbname here]
>
I still think we should display a 'hint' that createlang might fix the
problem when we report a problem with a missing language --- t