Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E47952E0050 for ; Thu, 10 Apr 2008 08:37:23 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92125-01 for ; Thu, 10 Apr 2008 08:37:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.bezdrat.net (mail.bezdrat.net [213.250.192.15]) by developer.postgresql.org (Postfix) with ESMTP id D12852E004F for ; Thu, 10 Apr 2008 08:37:16 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.bezdrat.net (Postfix) with ESMTP id 886D6C128 for ; Thu, 10 Apr 2008 13:37:14 +0200 (CEST) X-Virus-Scanned: amavisd-new at mail.bezdrat.net Received: from mail.bezdrat.net ([127.0.0.1]) by localhost (mail.bezdrat.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gIn3HH0zQTVU for ; Thu, 10 Apr 2008 13:37:13 +0200 (CEST) Received: from worm.fortech.cz (worm.fortech.cz [213.250.192.38]) by mail.bezdrat.net (Postfix) with ESMTP id 1FA3DC100 for ; Thu, 10 Apr 2008 13:34:06 +0200 (CEST) Message-ID: <47FDFB2E.3060503@fortech.cz> Date: Thu, 10 Apr 2008 13:34:06 +0200 From: Martin Edlman User-Agent: Thunderbird 2.0.0.12 (X11/20080226) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: pl/PgSQL, variable names in NEW References: <47FA034B.7090201@fortech.cz> <162867790804070511y7266c911w370db97a78c3c519@mail.gmail.com> <47FB51C7.6090509@fortech.cz> <20080408132157.GF5290@alvh.no-ip.org> In-Reply-To: <20080408132157.GF5290@alvh.no-ip.org> X-Enigmail-Version: 0.95.6 OpenPGP: id=89BE549F; url=http://edas.visaci.cz/#gpgkeys Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/66 X-Sequence-Number: 30605 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 |> I don't want to rewrite whole trigger to plPerl as I would have to use |> DBD-PgSPI. | | Huh? Certainly not -- there are functions in PL/Perl for this. See | spi_exec_query in | http://www.postgresql.org/docs/8.3/static/plperl-database.html Oh, I see. I have read the doc "...can be done via the function spi_exec_query described below, or via an experimental module DBD::PgSPI...", but missed the "OR" and thought that DBD::PgSPI is mandatory. Thanks. Martin - -- Regards, Martin Edlman Fortech, spol. s r.o, Ropkova 51, 57001 Litomyšl Public GPG key: http://edas.visaci.cz/#gpgkeys -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFH/fstqmMakYm+VJ8RAjLSAKCW4rqz2w1CaND8/BxAxLcOlwwziQCgjxsA PAAPqST5r5St08OgJsVkVK4= =ZUKV -----END PGP SIGNATURE-----