Search Postgresql Archives

Re: Two-phase commmit, plpgsql and plproxy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux