Re: Two questions about savepoints: Bug or feature?

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Two questions about savepoints: Bug or feature?
Date: 2004-08-03 14:14:12
Message-ID: Pine.LNX.4.44.0408031708420.24680-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Tue, 3 Aug 2004, Merlin Moncure wrote:

> > test=# ROLLBACK to devrim;
> > ROLLBACK
> >
> > ...and it goes on forever. Is it a feature or a bug?
>
> feature. You can rollback to a savepoint multiple times (0 or more
> savepoints might intervene)

When I wrote that e-mail, I could not think of a situation that someone
wanted to rollback to the same savepoint many times... But a few minutes
ago I got the point. Sorry.

> > Are these all intended behaviors? I thought we wouldn't be able to
> give
> > more than 1 same name to savepoints in a transaction, am I right?
>
> Nope. Read:
> http://www.destructor.de/firebird/1.5/savepoints.txt

Thanks for the link. Now things are more clear to me.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBD522tl86P3SPfQ4RAu6OAKCfs8Vy+p1FtS/xmOBXMKxhfmZWwACgqMRk
QJTgQaGYO3Z45Js6IIn3XvA=
=Y6Na
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-03 14:17:14 Re: Anybody have an Oracle PL/SQL reference at hand?
Previous Message Tom Lane 2004-08-03 14:10:45 Re: Anybody have an Oracle PL/SQL reference at hand?