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

CREATE INDEX
psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.
psql:sql/Pg-database.sql:828: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:836: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:839: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:841: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:843: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:845: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:855: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:858: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:868: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:871: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:929: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:932: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:935: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:938: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:960: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:963: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:989: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:992: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:994: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:996: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:998: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:1008: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:1010: ERROR: current transaction is aborted,
commands ignored until end of transaction block
psql:sql/Pg-database.sql:1012: ERROR: current transaction is aborted,
commands ignored until end of transaction block
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


So, I wonder what is the best and quickest way to fix this Flaw?

Thanks,
Robin
--
View this message in context:
http://www.nabble.com/After-Installing-a-Program-I-get-this-error%3A-psql%3Asql-Pg-database.sql%3A825%3A-ERROR%3A-language-%22plpgsql%22-does-not-exist-tp14709592p14709592.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Robin-Vossen wrote:
> Subject: [GENERAL] After Installing a Program I get this
> error: psql:sql/Pg-database.sql:825: ERROR: language
> "plpgsql" does not exist

Define the PL/pgSQL language as described in

http://www.postgresql.org/docs/current/static/app-createlang.html

Yours,
Laurenz Albe

On Wednesday 09 January 2008 3:02 am, Robin-Vossen wrote:
> CREATE INDEX
> psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
> HINT: You need to use "createlang" to load the language into the database.
<snip>
>
>
> So, I wonder what is the best and quickest way to fix this Flaw?
>
> Thanks,
> Robin
The solution is in the HINT:. The language needs to loaded with createlang.
plpgsql is shipped with Postgres it is not, however,  loaded by default.
--
Adrian Klaver
aklaver@comcast.net