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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Robin-Vossen <robin-vossen(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
Date: 2008-01-10 14:50:24
Message-ID: 20080110145024.GD10183@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-01-10 14:52:06 Re: Setting variables equal to elements from an Array
Previous Message Magnus Hagander 2008-01-10 14:49:31 Re: 8.3 Beta Incompatible Data Disaster