Re: Two-phase commmit, plpgsql and plproxy

On Thu, 2009-02-12 at 00:57 +0300, Igor Katson wrote:
> Thanks, Jeff. That's not good news, cause I am not able to do that.

There may be some creative solution, but I don't know plproxy well
enough to suggest one.

> The postgres manual says, that
> " The intended usage of the feature is that a prepared transaction will
> normally be committed or rolled back as soon as an external transaction
> manager has verified that other databases are also prepared to commit. "
>
> So does this "external transaction manager" exist? I am not clear about
> what it is.

PostgreSQL does not provide a transaction manager.

When you are dealing with multiple databases, the transaction manager
needs to make decisions like "this transaction failed on one node,
therefore we need to roll all the other transactions back".

I think you are basically trying to make plproxy into the transaction
manager. You might get some better suggestions from people who know
plproxy well.

Regards,
Jeff Davis