From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Ravi Katkar <Ravi.Katkar@infor.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Transaction with in function
Date: Wed, 26 May 2010 11:13:59 -0500
Message-ID: <4BFD02770200002500031AFF@gw.wicourts.gov> (raw)
In-Reply-To: <46AC8D44F3AE1F4888F137837D0DF635072561999F@INHYWEXMB2.infor.com>
References: <46AC8D44F3AE1F4888F137837D0DF635072561999F@INHYWEXMB2.infor.com>
Ravi Katkar <Ravi.Katkar@infor.com> wrote:
> I know that postgresql does not support nested transactions,
>
> I looking for solution for commit, rollback with in function. May
> be using the save point.
That is essentially the same as nested transactions, isn't it? Just
using SQL standard syntax?
> I were to use save point in function , when it would get commit.?
Each savepoint creates a subtransaction which will be included in
the top level transaction unless it or an intermediate savepoint is
rolled back. Nothing from the top level transaction is visible to
other transactions until the commit of the top level transaction.
If this and the docs don't make it clear, please post again:
http://www.postgresql.org/docs/8.4/interactive/sql-savepoint.html
If you do post again, please include your PostgreSQL version and an
explanation of what problem you're trying to solve. More specific
questions tend to elicit more useful responses:
-Kevin
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-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, Ravi.Katkar@infor.com
Subject: Re: Transaction with in function
In-Reply-To: <4BFD02770200002500031AFF@gw.wicourts.gov>
* 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