possible small contribution to the PostgreSQL manual? Example for two-phase commit section.

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: possible small contribution to the PostgreSQL manual? Example for two-phase commit section.
Date: 2009-04-02 01:07:34
Message-ID: d17c5b140904011807x6ff6bfb2o71d98295c3a366dd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. We're trying to implement two-phase commit and did not find a
complete working example in the manual. We found examples of the
separate pieces, but not the sequence in which to put them together.

Then we found this text,

"PREPARE TRANSACTION is used in place of regular COMMIT to perform
the 1st phase, COMMIT PREPARED and ROLLBACK PREPARED perform the final
2nd phase commit or abort."

I'd like to offer two examples to illustrate that, for possible
inclusion in the manual:

1. Here's the sequence that two-phase commits:

BEGIN;
update mytable set a_col='something' where red_id=1000;
PREPARE TRANSACTION 'foobar';
COMMIT PREPARED 'foobar';

2. Here's the sequence that rolls back, leaving the table unchanged:

BEGIN;
update mytable set a_col='something' where red_id=1000;
PREPARE TRANSACTION 'foobar';
ROLLBACK PREPARED 'foobar';

If there is somebody on this list involved with editing the manual, this message
is for you. :) Examples make new things clearer, and easier to learn.

Just a suggestion. :)

Best,
Aleksey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2009-04-02 06:22:32 Re: [GENERAL] string_to_array with empty input
Previous Message Leif B. Kristensen 2009-04-02 00:53:26 Re: [HACKERS] string_to_array with empty input