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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
