From: Volkan YAZICI <yazicivo@ttnet.net.tr>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: transactional shared variable in postgresql
Date: Sat, 18 Nov 2006 20:34:23 +0200
Message-ID: <20061118183423.GB1346@alamut> (raw)
In-Reply-To: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
References: <a97c77030611180430p764dac32ue19ade554ec80cbe@mail.gmail.com>
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.
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: yazicivo@ttnet.net.tr, mallah.rajesh@gmail.com
Subject: Re: transactional shared variable in postgresql
In-Reply-To: <20061118183423.GB1346@alamut>
* 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