Orthodox use of PQtransactionStatus

From: luca(dot)ciciriello(at)email(dot)it
To: pgsql-general(at)postgresql(dot)org
Cc: alessandra(dot)autunno(at)galileoavionica(dot)it
Subject: Orthodox use of PQtransactionStatus
Date: 2007-12-06 09:55:12
Message-ID: 25a54c8a7c5c90af78813a03d75a3263@85.18.140.153
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All.
Does somebody know where (some internet sites or sample code) I can achieve
a good understanding in the use of the
status PQTRANS_IDLE, PQTRANS_ACTIVE, PQTRANS_INTRANS, PQTRANS_INERROR,
PQTRANS_UNKNOWN using the lib function
PQtransactionStatus?
I need to use this flags in order to discipline some BEGIN-COMMIT blocks in
a multithreading Windows/Linux
environment.

Each thread uses a separate db connection and shouldn't have any interaction
with the other threads, but I still
have messages as "WARNING: There is already a transaction in progress" and
"WARNING: There is no transaction in
progress". A further information is that the DB operation involved in each
thread is a store in a table. This table
is the same for each thread.

Thanks in advance.

Luca.
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
PARTI CON TODOMONDO: occasioni speciali a prezzi straordinari, fino al 50%
di sconto su voli e viaggi!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7277&d=20071206

Browse pgsql-general by date

  From Date Subject
Next Message Frank Millman 2007-12-06 10:06:38 Re: simple update on boolean
Previous Message Daniel Drotos 2007-12-06 09:47:12 Re: simple update on boolean