Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 8187F9F9FB1 for ; Sat, 18 Nov 2006 13:38:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 12868-09 for ; Sat, 18 Nov 2006 17:38:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fep03.ttnet.net.tr (mail.ttnet.net.tr [212.175.13.129]) by postgresql.org (Postfix) with ESMTP id E03F19F9425 for ; Sat, 18 Nov 2006 13:38:17 -0400 (AST) Received: from (unknown) by AVGW-I-1.ttnet.net.tr with smtp id 3bd2_930434be_772b_11db_9677_001422175f0e; Sat, 18 Nov 2006 19:38:17 +0200 Received: from alamut ([85.101.16.108]) by fep03.ttnet.net.tr with ESMTP id <20061118173807.PLBW16486.fep03.ttnet.net.tr@alamut>; Sat, 18 Nov 2006 19:38:07 +0200 Received: from (unknown [85.101.16.108]) by AVGW-I-5.ttnet.net.tr with smtp id 101b_8d1a1d66_772b_11db_918c_001422143cb8; Sat, 18 Nov 2006 19:38:06 +0200 Date: Sat, 18 Nov 2006 19:36:56 +0200 From: Volkan YAZICI To: Rajesh Kumar Mallah Cc: pgsql-sql@postgresql.org Subject: Re: transactional shared variable in postgresql Message-ID: <20061118173656.GA1346@alamut> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-NAI-Spam-Rules: 0 Rules triggered X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.615 tagged_above=0 required=5 tests=BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: ** X-Archive-Number: 200611/195 X-Sequence-Number: 26847 Hi, On Nov 18 06:00, Rajesh Kumar Mallah wrote: > Is there any way to set a variable from a web application (using > dbi/perl , libpq etc), and access the same variable from a C trigger > inside a transaction ? Why don't you use a temporary table for that purpose? Regards.