Thread: Problem with plpgsql installation!!!

Problem with plpgsql installation!!!

From
"Ing. Jhon Carrillo"
Date:
Hi,  I have a problem   installing  "plpgsql" in  postgreSQL 7.4.6 on linux.
Those Scripts were create succesfull but when i try to create some "store
procedure(function)" no gererate errors, no generate nothing  in the pgadmin
III, i don't  know what is the problem.


 '/usr/lib/postgresql/plpgsql.so'  exist!!

those are the script:


CREATE FUNCTION public.plpgsql_call_handler () RETURNS language_handler AS
     '/usr/lib/postgresql/plpgsql.so' LANGUAGE 'C' VOLATILE;



CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
  HANDLER public.plpgsql_call_handler;



help me please.

thanks.