[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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