PostgreSQL - Language pgplsql does not exist despite running CREATE LANGUAGE

Question

I just tried to create my first plpgsql function. When executing the script, I get

ERROR: language "‘plpgsql’" does not exist

I then run the command CREATE LANGUAGE plpgsql; which shows the following error:

ERROR: language "plpgsql" already exists

Commands are being run on the same database.

Regards

Peter

please post your function's complete code -- I bet there's some typo in it... — Alex Martelli
– Alex Martelli, Commented Jan 23, 2010 at 5:38

Heiko Rupp · Accepted Answer · 2012-02-02 09:35:29Z

22

use this command:

$: createlang -d dbname plpgsql

Heiko Rupp

31.1k13 gold badges86 silver badges120 bronze badges

answered Feb 2, 2012 at 8:58

ls270400

3212 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user80168 · Accepted Answer · 2010-01-23 09:30:41Z

18

please notice that you have extra characters in your error. Most likely you wrote:

create function ... language ‘plpgsql’

kind of like mysql quotes things. It's bad syntax. Just make it

create function ... language plpgsql

answered Jan 23, 2010 at 9:30

user80168