Re: transactional shared variable in postgresql

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: transactional shared variable in postgresql
Дата
Msg-id a97c77030611180958q2975996eva72014c20e619043@mail.gmail.com
обсуждение исходный текст
Ответ на Re: transactional shared variable in postgresql  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Список 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 по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Random()
Следующее
От: Volkan YAZICI
Дата:
Сообщение: Re: transactional shared variable in postgresql