[Solved] Postgresql Language

[gotik]

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.

 

 

[Guest Geoff]

Moving thread...

[Guest Geoff]

I would suggest that you look at the docs:

 

http://www.postgresql.org/docs/8.2/static/...telanguage.html

 

 

[gotik]

yes I know use the command

CREATE LANGUAGE plpgsql;

 

but...

ERROR: must be superuser to create procedural language

 

 

[Guest Geoff]

Do you want me to run that command as root?

[gotik]

Just if it's possible,

I'll be very grateful

[Guest Geoff]

server?

[gotik]

Johnny

[Guest Geoff]

Escalating request....

 

@djbob

 

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

 

 

CREATE LANGUAGE plpgsql;

[Ashoat]

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';

[gotik]

Hi djbob,

 

I need just the plpgsql, not C

 

Thanks for your time.

[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.

[gotik]

Yep, you are right,

 

 

 

I need plpgsql to create my functions.

[Ashoat]

Okay, is it working now?

[gotik]

no :S

 

Error de SQL:

 

ERROR: language "plpgsql" does not exist

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