X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8CC98B9F43 for ; Thu, 3 Feb 2005 15:27:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40176-04 for ; Thu, 3 Feb 2005 15:27:45 +0000 (GMT) Received: from rs26s12.datacenter.cha.cantv.net (rs26s12.datacenter.cha.cantv.net [200.44.33.31]) by svr1.postgresql.org (Postfix) with ESMTP id D78408B9F4B for ; Thu, 3 Feb 2005 15:27:47 +0000 (GMT) Received: from tgusta2 (dC9F37969.dslam-14-24-3-06-01-02.fsl.dsl.cantv.net [201.243.121.105]) by rs26s12.datacenter.cha.cantv.net (8.13.0/8.13.0/3.0) with SMTP id j13FRlIZ010882 for ; Thu, 3 Feb 2005 11:27:47 -0400 X-Matched-Lists: [] Message-ID: <006301c50a04$ef97d820$1400a8c0@tgusta2> Reply-To: "Ing. Jhon Carrillo" From: "Ing. Jhon Carrillo" To: References: <456a44761a121aa6792c7369e5d883217c246492@postgresql.org> Subject: Problem with plpgsql installation!!! Date: Thu, 3 Feb 2005 11:27:56 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: ClamAV 0.80/664/Thu Jan 13 11:13:05 2005 clamav-milter version 0.80j on rs26s12.datacenter.cha.cantv.netClamAV 0.80/664/Thu Jan 13 11:13:05 2005 clamav-milter version 0.80j on rs26s12.datacenter.cha.cantv.netClamAV 0.80/664/Thu Jan 13 11 X-Virus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.54 tagged_above=0 required=5 tests=AWL, PLING_PLING X-Spam-Level: X-Archive-Number: 200502/21 X-Sequence-Number: 16189 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.