Skip site navigation (1) Skip section navigation (2)

Multiple postgresql functions in a single transaction

From: "Jyoti Seth" <jyotiseth2001(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Multiple postgresql functions in a single transaction
Date: 2008-02-06 06:21:10
Message-ID: 000c01c86888$79a497d0$6cedc770$@com (view raw or flat)
Thread:
Lists: pgsql-sql
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






In response to

Responses

pgsql-sql by date

Next:From: Robins TharakanDate: 2008-02-06 07:23:57
Subject: Re: Multiple postgresql functions in a single transaction
Previous:From: Volkan YAZICIDate: 2008-02-05 22:39:39
Subject: Re: Cast in PG 8.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group