Re: MyISAM vs InnoDB

[Lars Heidieker]

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


On 7 Nov 2006, at 12:35, Jochem van Dieten wrote:

> On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
>> Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
>>>
>>> PostgreSQL supports 2 phase commit. IIRC except for transaction
>>> interleaving, join and suspend/resume it supports XA. I think  
>>> that puts it
>>> about on par with Ingres and Firebird.
>>
>>         I would have to analyze better, but I think you are  
>> mistaken, sadly.
>
> Please share your analysis with us.
>
> Jochem

 From the Handbook Postgresql 8.1 there are
PREPARE TRANSACTION transaction_id
COMMIT PREPARED transaction_id
ROLLBACK PREPARED transaction_id

and it states PREPARE TRANSACTION -- prepare the current transaction  
for two-phase commit


- --

Viele Grüße,
Lars Heidieker

lars@stripped
http://paradoxon.info

- ------------------------------------

Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind.
      -- Friedrich Nietzsche



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFFUIXPDAkIK9aNPuIRAjBnAJ92IupcD1/yAcvD88IW2szNieCg0gCgggis
CJQvtMAlz6p3EWs2cc/ZstE=
=IDBz
-----END PGP SIGNATURE-----