gotik

Yes!

Thank you so much, sorry for the inconvenience

It is not necessary, you can access to my schema and execute the command.

My schema is gespro on database gespro_db.

Hi djbob,

SELECT COUNT(*) FROM pg_language WHERE lanname = 'plpgsql';

count

0

and I try to create a function

CREATE OR REPLACE FUNCTION dologin(IN i_user varchar, IN i_password varchar, OUT o_group integer) RETURNS INTEGER AS

$$

DECLARE

BEGIN

SELECT group_id INTO o_group FROM users WHERE nick=i_user AND password=i_password;

IF NOT FOUND THEN

SELECT 0 INTO o_group;

END IF;

RETURN;

END;

$$ LANGUAGE plpgsql;

Because the plgpsql is not loaded by default I should to be loaded at the schema you want.

I try on a Centos Virtual Machine and loaded the plpsql as postgres and other user wiht other schema cant access it.

Thanks for your time djbob.

no :S

Error de SQL:

ERROR: language "plpgsql" does not exist

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

Yep, you are right,

I need plpgsql to create my functions.

Hi djbob,

I need just the plpgsql, not C

Thanks for your time.

Johnny

Just if it's possible,

I'll be very grateful

yes I know use the command

CREATE LANGUAGE plpgsql;

but...

ERROR: must be superuser to create procedural language

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.