Re: PostgreSQL and distributed transactions

Jayadevan M <Jayadevan.Maymala@ibsplc.com> writes:
> But the initial setup for the client is done by 'Admin' and in that
> work-flow, we need distributed transactions. The transaction will start
> from the 'Admin" server, do some inserts on the 'Client' server and then
> either rollback or commit on both the servers. Is it possible to do this
> with PostgreSQL? Any helpful links?

See about 2 Phase Commit, but you will need a transaction manager I guess :

  http://www.postgresql.org/docs/current/static/sql-prepare-transaction.html

Regards,
--
dim