Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)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