Skip site navigation (1) Skip section navigation (2)

Transaction XID

From: laurent(dot)marzullo(at)one-d(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction XID
Date: 2004-06-30 15:18:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general


I would like to know if I'm able to do the following with postgreSQL:

In a process A:
Creating a transaction, and so getting a new PGconn*
Beginning a transaction on this connection, with "BEGIN"

In a process B (in another memory space than the process A):
*** TAKE the transaction, connection (or anything else), that
*** allow me to execute SQL statment in the SAME transaction as
*** the one created in process A

And then in process A,
Committed the transaction, and modification make in process B will
be available.

And all of this, to implement a minimal CosTransactions CORBA service
for postgreSQL.

My first idea was to pass as binary data the PGconn from process A to
process B by writing it in the file system, but I do not know how to get
the size of the PGconn structure ? And, is this will work ?

Thanks & regards
Laurent Marzullo

pgsql-general by date

Next:From: Tom LaneDate: 2004-06-30 15:47:37
Subject: Re: substring syntax with regexp
Previous:From: Tom LaneDate: 2004-06-30 15:15:49
Subject: Re: sharing tcl proc's between functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group