Jump to content

[Solved] Postgresql Language


gotik

Recommended Posts

Good Night,

 

I created my functions in postgresql, but these functions need language plpgsql

 

ERROR: language "plpgsql" does not exist

HINT: Use CREATE LANGUAGE to load the language into the database.

 

It's possible to create the language?.

 

Thanks for your time.

 

 

Link to comment
Share on other sites

Guest Geoff

Escalating request....

 

@djbob

 

SSH to johnny, run 'psql', and run the following query:

 

 

CREATE LANGUAGE plpgsql;

Link to comment
Share on other sites

Geoff: Your root privileges are not for running arbitrary commands. Escalate threads on any requests to run commands that you don't entirely, completely understand.

 

gotik: Are you sure you don't want me to run the following?

CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
             '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

    CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
             HANDLER plpgsql_call_handler
             LANCOMPILER 'PL/pgSQL';

Link to comment
Share on other sites

Guest Geoff
I need just the plpgsql, not C

 

C is the language that /usr/local/pgsql/lib/plpgsql.so is written in.

 

You won't be adding that language to postgreSQL.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...