From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
---|---|
To: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: concurrent transactions inside the same connection |
Date: | 2006-04-19 09:43:58 |
Message-ID: | 52EF20B2E3209443BC37736D00C3C13807FD4580@EXADV1.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> I have included below a fragment of a discussion from the freepascal
mailing
> list. Apparently, some folks expect to be able to start multiple
transactions
[...]
> inside the *same* database connection.
>
> My feeling is that this is a false problem, caused by some
interbase/firebird
> or delphi habits . But ... the poster claims that Oracle and
SqlServer
> have such a feature ( Oracle has 'named' transactions - but these
> names seem to be just labels ) - is this true ?
I can only speak for Oracle:
Transaction names are just labels, that is correct.
There is, however, something called an 'autonomous transaction' in
PL/SQL
stored procedures and triggers. A stored procedure can start a new
transaction,
independent from the current context.
Once you return from the stored procedure, the old transaction is
resumed.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-04-19 10:25:30 | Re: concurrent transactions inside the same connection |
Previous Message | Adrian Maier | 2006-04-19 09:31:23 | concurrent transactions inside the same connection |