Transaction context switching?

From: "Philipp Leibfried" <pleibfried(at)speech-design(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction context switching?
Date: 2002-07-26 13:15:55
Message-ID: fYb09.455446$om4.4078372@news.easynews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

we plan to use PostgresSQL it as a database back-end for multi-threaded
CORBA server(s) written in C++. From the DB point of view, that's just a
multithreaded C++ client. This multithreaded client can now use several
different transactions "simultaneously" (meaning each thread may have it's
'own' active transaction). It seems to me the only way of telling PostgreSQL
that a command should be executed in the context of a certain transaction is
by assigning one distinct DB connection to each thread.

Is this correct? If so, this could become a problem, since a DB is a rather
'expensive' resource, as far as I understand these things.
Or is there another possibility to explicitly refer to a specific
transaction when issuing commands to the DB via the C++ API?

TIA and regards
-Philipp Leibfried
Speech Design GmbH

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2002-07-26 13:27:40 Re: Evolving databases (eg deleting columns)
Previous Message Janning Vygen 2002-07-26 13:14:37 slow update