Re: Two-phase commit security restrictions - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Two-phase commit security restrictions
Date
Msg-id Pine.OSF.4.61.0410132221510.58068@kosh.hut.fi
Whole thread Raw
In response to Re: Two-phase commit security restrictions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Wed, 13 Oct 2004, Peter Eisentraut wrote:

> Heikki Linnakangas wrote:
>> What kind of security restrictions do we want for prepared
>> transactions? Who has the right to finish a transaction that was
>> started by user A? At least the original user, I suppose, but who
>> else?
>
> Do we not require transaction initiation and conclusion to happen in the
> same session, so that the transaction could be considered a
> session-local object?

No. After we have told the transaction manager that the transaction has 
been successfully prepared, we must not lose it. Otherwise we break the 
atomicity of the global transaction.

Successful preparation is a promise to the TM that we will be able to 
finish the 2nd phase commit later, no matter what.

- Heikki


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Two-phase commit security restrictions
Next
From: Bruce Momjian
Date:
Subject: Re: more dirmod CYGWIN