Re: transactional shared variable in postgresql - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Re: transactional shared variable in postgresql
Date
Msg-id a97c77030611180958q2975996eva72014c20e619043@mail.gmail.com
Whole thread Raw
In response to Re: transactional shared variable in postgresql  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
List pgsql-sql
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.
>


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Random()
Next
From: Volkan YAZICI
Date:
Subject: Re: transactional shared variable in postgresql