X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1D90E9DCA15 for ; Sat, 18 Feb 2006 03:42:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83659-08 for ; Sat, 18 Feb 2006 03:42:10 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web36808.mail.mud.yahoo.com (web36808.mail.mud.yahoo.com [209.191.85.59]) by postgresql.org (Postfix) with SMTP id DEB149DCA03 for ; Sat, 18 Feb 2006 03:42:07 -0400 (AST) Received: (qmail 72602 invoked by uid 60001); 18 Feb 2006 07:42:08 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=NrXFL+aiFElnJo8mqaO6kh7nU/beR2TkTRRrY+2pmyhrdOpMBeYTHFRNDgix4Y3nU45kiPTtYnIx+ujgiWQCLToTPKBlxyHBukZzLfa2WLSAyJykQGbYJ1hopQe7LL45bOSnNyKFFslNuOc+CFgz0E71DCJg0yH2mTlDbnF5LH8= ; Message-ID: <20060218074208.72600.qmail@web36808.mail.mud.yahoo.com> Received: from [61.5.41.18] by web36808.mail.mud.yahoo.com via HTTP; Sat, 18 Feb 2006 07:42:08 GMT Date: Sat, 18 Feb 2006 07:42:08 +0000 (GMT) From: fathur rohman Subject: Trigger and PL Registration Problem To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200602/228 X-Sequence-Number: 20649 Hi Every Body, i'v declared my trigger function with plpgsql. there's problems with statements inside IF .. END IF block that not executed at all. i guess from plpgsql problem so i registering procedural language that more friendly to me, thereis plpython/plpythonu, but the problem rise again. this is illustration : J:\Program Files\PostgreSQL\8.1\bin>createlang -U postgres -d template1 plpythonu Error messages: createlang: language installation failed: ERROR: could not load library "J:/Pro gram Files/PostgreSQL/8.1/lib/plpython.dll": The specified module could not be f ound. my questions : 1. whats wrong with the trigger. 2. although the directory already exists, an error message "The specified module could not be f ound".raised when i registering pl, whats the problem? 3. thanks all. My Specs : - Win 2000 Advanced Server Powered NAS - Borland Delphi 7 - PGOleDB 1.0.0.19 - PostgreSQL 8.1.1 - Intel P4 2.4 GHz, 256 MB RAM. Send instant messages to your online friends http://uk.messenger.yahoo.com