Problem with plpgsql installation!!!

From: "Ing(dot) Jhon Carrillo" <jdigital(at)cantv(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problem with plpgsql installation!!!
Date: 2005-02-03 15:27:56
Message-ID: 006301c50a04$ef97d820$1400a8c0@tgusta2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Pam Eggler 2005-02-03 16:03:34 vacuum ran out of space and now i cant get back into db
Previous Message Pallav Kalva 2005-02-03 14:54:50 Re: Online Backup and WAL archives