开发者

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开发者_JAVA百科 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


use this command:

$: createlang -d dbname plpgsql


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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜