On sön, 2010-01-24 at 19:43 +0200, Heikki Linnakangas wrote:
> "PREPARE TRANSACTION is not intended for use in applications or in
> interactive sessions. It's purpose is to allow an external transaction
> manager to perform atomic global transactions across multiple
> databases
> or other transactional resources. Unless you're writing a transaction
> manager, you probably shouldn't be using PREPARE TRANSACTION"
I have never had a chance to use one of these "transaction managers".
I'm probably using it in a non-orthodox way then. What is the
difference between a transaction manager and an application that opens
multiple connections and does PREPARE + COMMIT PREPARED across them?