| 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: | Whole Thread | Raw Message | 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
| 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 |