PostgreSQL - Language pgplsql does not exist despite running CREATE LANGUAGE

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

Answers


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

use this command:

$: createlang -d dbname plpgsql

Need Your Help

Iterating over each image in a list and define a hover state using jQuery

javascript jquery css hover

I'm trying to do something very simple: make a border-bottom under an image in a slider when the user hovers over it. I'm writing a jQuery function for this because I want to make something hover w...

How to properly embed a html conditional code in php

php html wordpress

I have a situation and I am struggling to embed 2 conditional html code sequences inside of a PHP file. I was thinking, of using include PHP function to call two separate external html files

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.