From: Ing. Jhon Carrillo <jdigital@cantv.net>
To: pgsql-admin@postgresql.org
Subject: Problem with plpgsql installation!!!
Date: Thu, 3 Feb 2005 11:27:56 -0400
Message-ID: <006301c50a04$ef97d820$1400a8c0@tgusta2> (raw)
References: <456a44761a121aa6792c7369e5d883217c246492@postgresql.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jdigital@cantv.net
Subject: Re: Problem with plpgsql installation!!!
In-Reply-To: <006301c50a04$ef97d820$1400a8c0@tgusta2>
References: <456a44761a121aa6792c7369e5d883217c246492@postgresql.org> <006301c50a04$ef97d820$1400a8c0@tgusta2>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox