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

From Volkan YAZICI
Subject Re: transactional shared variable in postgresql
Date
Msg-id 20061118183423.GB1346@alamut
Whole thread Raw
In response to transactional shared variable in postgresql  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
List 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.


pgsql-sql by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: transactional shared variable in postgresql
Next
From: Tom Lane
Date:
Subject: Re: transactional shared variable in postgresql