On Mon, Oct 12, 2009 at 5:18 PM, Bill Todd wrote:
> Scott Marlowe wrote:
>
> On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd wrote:
>
>
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
> ...more stuff...
> COMMIT;
> COMMIT;
>
>
> Postgresql u
Jeff Davis escribió:
> On Mon, 2009-10-12 at 16:18 -0700, Bill Todd wrote:
> > Savepoints do not provide the same functionality as nested or parallel
> > transactions because you cannot commit a savepoint.
>
> What does it mean to "commit" a subtransaction or savepoint? What can
> you do with a su
On Mon, 2009-10-12 at 16:18 -0700, Bill Todd wrote:
> Savepoints do not provide the same functionality as nested or parallel
> transactions because you cannot commit a savepoint.
What does it mean to "commit" a subtransaction or savepoint? What can
you do with a subtransaction that you can't do wi
Scott Marlowe wrote:
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd wrote:
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
Postgresql uses savepoints.
Savepoints do not provide the same functionality
On Sun, Oct 11, 2009 at 07:41:54PM -0700, Bill Todd wrote:
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
>...more stuff...
> COMMIT;
> COMMIT;
It depends what you want to have happen when the outer transaction
rolls back. If you wan
Bill Todd wrote:
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
no, but in recent versiosn, you can use SAVEPOINT to achieve much the
same effect.
http://www.postgresql.org/docs/current/static/sql-savepoi
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd wrote:
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
> ...more stuff...
> COMMIT;
> COMMIT;
Postgresql uses savepoints.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
Bill
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alvaro Herrera
Sent: Friday, July 06, 2007 9:49 AM
To: Nykolyn, Andrew
Cc: John DeSoi; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Nested Transactions in PL/pgSQL
Nykolyn, Andrew wrote:
> My r
Nykolyn, Andrew wrote:
> My real issue is not that I need subtransactions but I need to flush the
> buffer so that I can regain memory for my stored procedure to complete
> without getting a memory error.
Please don't top-post.
Normal operation does not "fill buffers", thus they don't need any
fl
DeSoi
Cc: Nykolyn, Andrew; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Nested Transactions in PL/pgSQL
John DeSoi wrote:
>
> On Jul 5, 2007, at 1:34 PM, Nykolyn, Andrew wrote:
>
> >Is it possible to nest transactions within a stored procedure? I
> >have a stored
John DeSoi wrote:
>
> On Jul 5, 2007, at 1:34 PM, Nykolyn, Andrew wrote:
>
> >Is it possible to nest transactions within a stored procedure? I
> >have a stored procedure that calls many other stored procedures and
> >what happens it that after a certain amount of time the server runs
> >ou
On Jul 5, 2007, at 1:34 PM, Nykolyn, Andrew wrote:
Is it possible to nest transactions within a stored procedure? I
have a stored procedure that calls many other stored procedures and
what happens it that after a certain amount of time the server runs
out of shared memory. I know I can i
Is it possible to nest transactions within a stored procedure? I have a
stored procedure that calls many other stored procedures and what
happens it that after a certain amount of time the server runs out of
shared memory. I know I can increase the PostgreSQL shared memory.
However, that would be
Jim Rosenberg <[EMAIL PROTECTED]> writes:
> How realistic is it to expect nested transactions to make it into
> PostgreSQL 7.5?
I wouldn't hold my breath. It's a complex problem.
regards, tom lane
---(end of broadcast)---
Gilles DAROLD wrote:
>
> jprem wrote:
>
> > hello ,
> >postgreqsl 6.5.3 does not support nested transactions.
> > so i don't think it will be suitable for e-com application.isn't it ?
> > does postgreqsl 7.0 support nested transacions ? is postgresql 7.0 a
> > stable version ?
>
>
jprem wrote:
> hello ,
>postgreqsl 6.5.3 does not support nested transactions.
> so i don't think it will be suitable for e-com application.isn't it ?
> does postgreqsl 7.0 support nested transacions ? is postgresql 7.0 a
> stable version ?
Hi,
I have around 4000 online shop runnin
On Mon, 26 Jun 2000, Andrea Aime wrote:
> does postgres support nested transactions?
No.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
18 matches
Mail list logo
