List:General Discussion« Previous MessageNext Message »
From:Lars Heidieker Date:November 7 2006 1:10pm
Subject:Re: MyISAM vs InnoDB
View as plain text  
-----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-----
Thread
MyISAM vs InnoDBFrancis31 Oct
  • RE: MyISAM vs InnoDBJimmy Guerrero31 Oct
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA1 Nov
    • Re: MyISAM vs InnoDBMiles Thompson1 Nov
      • Re: MyISAM vs InnoDBJon Ribbens1 Nov
    • Re: MyISAM vs InnoDBPaul McCullagh1 Nov
    • Re: MyISAM vs InnoDBmos1 Nov
  • Re: MyISAM vs InnoDBMartijn Tonies1 Nov
    • Re: MyISAM vs InnoDBmos1 Nov
      • Re: MyISAM vs InnoDBJochem van Dieten1 Nov
        • Re: MyISAM vs InnoDBmos1 Nov
          • Re: MyISAM vs InnoDBJochem van Dieten2 Nov
  • Re: MyISAM vs InnoDBEdward Macnaghten1 Nov
  • Re: MyISAM vs InnoDBEdward Macnaghten1 Nov
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA2 Nov
    • Re: MyISAM vs InnoDBJochem van Dieten2 Nov
  • Re: MyISAM vs InnoDBMartijn Tonies2 Nov
    • Re: MyISAM vs InnoDBmos2 Nov
  • Re: MyISAM vs InnoDBMartijn Tonies2 Nov
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA2 Nov
  • Re: MyISAM vs InnoDBMartijn Tonies2 Nov
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA2 Nov
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA2 Nov
  • Re: MyISAM vs InnoDBMartijn Tonies3 Nov
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA6 Nov
  • Re: MyISAM vs InnoDBLeandro Guimarães Faria Corcete DUTRA6 Nov
    • Re: MyISAM vs InnoDBJochem van Dieten7 Nov
      • Re: MyISAM vs InnoDBLars Heidieker7 Nov
  • Re: MyISAM vs InnoDBMartijn Tonies6 Nov