注意:使用pg_pltemplate信息代替CREATE LANGUAGE参数 [英] NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters

问题描述

当我在PG 8.4中运行此SQL语句时，我收到此错误消息(如标题所示):

I am getting this error message (shown in title), when I run this SQL statement in PG 8.4:

psql -h localhost -U postgres -d mydb -c "CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler VALIDATOR plpgsql_validator"

是什么原因造成的(它曾经与早期版本的PG一起使用)，如何解决?

What's causing this (it used to work with earlier versions of PG), and how do I resolve it?

推荐答案

此程序已简化.对于plpgsql，只需使用:

CREATE LANGUAGE plpgsql;

该错误消息告诉您，plpgsql是系统表pg_pltemplate中列出的许多预定义语言之一.看看吧:

The error message tells you, that plpgsql is among a number of predefined languages listed in the system table pg_pltemplate. Just have a look:

SELECT * FROM pg_pltemplate;

在PostgreSQL 9.0和更高版本中，默认情况下预先安装了PL/pgSQL.

In PostgreSQL 9.0 and later, PL/pgSQL is pre-installed by default.

这篇关于注意:使用pg_pltemplate信息代替CREATE LANGUAGE参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！