From: | Philippe Hajjar <PHajjar(at)isg-service(dot)com> |
---|---|
To: | "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Possible bug with regards to multiple persistant connections |
Date: | 2003-03-19 21:57:15 |
Message-ID: | 306238A60C8CD411996C00010224313D36AA6E@NTSERV01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The operating environment in which this occurred is:
Apache 1.3.27
PHP 4.2.3
PostgreSQL 7.3.2
Redhat Linux 7.2
ADODB for PHP version 3.10
I have a database with an associated owner. I connect using a to this
database and begin a transaction and start doing inserts and updates.
However, I want to commit some other data to the same database outside of
the transaction so I open a second persistant connection under the same user
account and I write this information using an INSERT. In the first
connection, I roll back the transaction and the insert I did under the
second connection also gets rolled back. Is this supposed to occur?
Perl - The programming equivalent of duct tape.
Philippe Hajjar
Programmer
Interactive Services Group / Netensity.net
http://www.isg-service.com
(856) 824-9401 x33
phajjar(at)isg-service(dot)com
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 3/17/2003
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-19 22:50:45 | Re: Bug #914: Possible bug with regards to multiple persistant connections |
Previous Message | pgsql-bugs | 2003-03-19 21:55:09 | Bug #914: Possible bug with regards to multiple persistant connections |