Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • Last Modified:

How to Install plpgsql in Postgres 7.3 ?

Hello experts,
I had to install a database script on a Postgres 7.3 server, but I get an error when installing stored procedures.
The error stated that the language plpgsql was not supported.
I tried to create it, using:

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql
   HANDLER "plpgsql_call_handler"
   VALIDATOR "pg_catalog"."plpgsql_validator";

but I get an error saying the function plpgsql_call_handler wasn't found.
Does anybody knows how can I install it?
0
jorgesv13
Asked:
jorgesv13
1 Solution
 
earth man2Commented:
as user postgres issue command

createlang plpgsql DBNAME
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now