From: Jyoti Seth <jyotiseth2001@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Multiple postgresql functions in a single transaction
Date: Wed, 6 Feb 2008 11:51:10 +0530
Message-ID: <000c01c86888$79a497d0$6cedc770$@com> (raw)
In-Reply-To: <87d4rbm3is.fsf@ttmail.com>
References: <47A8B788.6010304@gmail.com>
<87d4rbm3is.fsf@ttmail.com>
Hi,
I have two postgresql functions. One function is calling another function
for certain value. I want that these two functions work under single
transaction so that even if the value gets generated in the second function
and the first function that calls the second function fails. Then the value
generated in the second function should also roll back.
Please let me know if we can execute two functions of postgresql in a single
transaction.
Thanks,
Jyoti Seth
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: jyotiseth2001@gmail.com
Subject: Re: Multiple postgresql functions in a single transaction
In-Reply-To: <000c01c86888$79a497d0$6cedc770$@com>
* 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