gotik
-
Posts
10 -
Joined
-
Last visited
Posts posted by gotik
-
-
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.
-
-
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.
[Solved] Postgresql Language
in Escalated Requests
Posted
Yes!
Thank you so much, sorry for the inconvenience