Re: transactional shared variable in postgresql

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: transactional shared variable in postgresql
Date: 2006-11-18 18:34:23
Message-ID: 20061118183423.GB1346@alamut
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ?

Also you may consider using a sequence for storing an integer value.
This approach will probably work faster than a temporary table, by the
limitation of variable format to be integer.

Regards.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-11-18 18:40:10 Re: transactional shared variable in postgresql
Previous Message Rajesh Kumar Mallah 2006-11-18 17:58:34 Re: transactional shared variable in postgresql