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: 1088608686.40e2d9ae700ee@ssl0.ovh.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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

Browse pgsql-general by date

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