From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Volkan YAZICI <yazicivo@ttnet.net.tr>
Cc: pgsql-sql@postgresql.org
Subject: Re: transactional shared variable in postgresql
Date: Sat, 18 Nov 2006 23:28:34 +0530
Message-ID: <a97c77030611180958q2975996eva72014c20e619043@mail.gmail.com> (raw)
In-Reply-To: <20061118173656.GA1346@alamut>
References: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
<20061118173656.GA1346@alamut>
On 11/18/06, Volkan YAZICI <yazicivo@ttnet.net.tr> wrote:
> 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?
sounds good, what i understand you mean to say that i create a temp table
(with on commit drop option) insert my value there and read the value
from inside the trigger.
i do not know about the performance aspect of this approach though.
i was thinking of a method that could be performed everytime my webapp
connected to database.
regds
mallah.
>
>
> Regards.
>
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah.rajesh@gmail.com, yazicivo@ttnet.net.tr
Subject: Re: transactional shared variable in postgresql
In-Reply-To: <a97c77030611180958q2975996eva72014c20e619043@mail.gmail.com>
* 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