[subxacts] Savepoint syntax

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: [subxacts] Savepoint syntax
Date: 2004-07-14 19:03:02
Message-ID: 20040714190302.GB15098@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Ok people,

After the last holy war on syntax issues I have been convinced that
savepoints are not that brain dead as it appears. (They nest correctly
and "release" is equivalent to my "subcommit"). The only bitter point
is that on ROLLBACK TO the same savepoint is created again
automatically.

So I have dropped the idea of the propietary syntax. This patch
implements proper savepoint syntax. Includes regression tests but no
documentation is provided yet.

Note that this does not include other patches I'm working on, regarding
PGPROC, the password file, large objects, whole-tree abort on deadlock,
handling of subxacts in functions etc. I'll submit those separately.
(It does include reverting XactLockTableWait to the previous state
though).

Note that I created a new ERRCODE class, 3B000, "Savepoint Exception",
with a single member, "Invalid Specification" 3B001. This is what the
standard mandates when you RELEASE a non existant savepoint, etc. Hope
this is OK. Also, you can't create or release a savepoint on aborted
state (only COMMIT, END, ROLLBACK and ROLLBACK TO are accepted).

Please test, review and apply. If anyone is able to crash the server
using this I'll be most interested.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Thou shalt study thy libraries and strive not to reinvent them without
cause, that thy code may be short and readable and thy days pleasant
and productive. (7th Commandment for C Programmers)

Attachment Content-Type Size
savepoints-1.patch text/plain 67.3 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Andreas Pflug 2004-07-14 19:10:09 Re: serverlog rotation/functions
Previous Message Stefan Kaltenbrunner 2004-07-14 18:18:01 Re: add missing options to pg_dumpall