Postgres Pro
Downloads
Home   >   mailing lists

Re: After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist - Mailing list pgsql-general

From Magnus Hagander
Subject Re: After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
Date
Msg-id 20080110145024.GD10183@svr2.hagander.net
Whole thread Raw
In response to After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist  (Robin-Vossen <robin-vossen@hotmail.com>)
List pgsql-general
Tree view 
On Wed, Jan 09, 2008 at 03:02:53AM -0800, Robin-Vossen wrote:
>
> So I thought lets add the language I miss.
> doing:
> createlang -d ledgersmb -U ledgersmb plpgsql
> I keep getting:
> createlang: language installation failed: ERROR: permission denied for
> language c

You must run creatlang with a superuser account, which ledgersmb obviously
isn't. Probably you need to use the user "postgres".

//Magnus

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: 8.3 Beta Incompatible Data Disaster
Next
From: Sim Zacks
Date:
Subject: 8.2.4 serious slowdown