From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | phajjar(at)isg-service(dot)com, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Bug #914: Possible bug with regards to multiple persistant connections |
Date: | 2003-03-19 22:50:45 |
Message-ID: | 12243.1048114245@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
pgsql-bugs(at)postgresql(dot)org writes:
> I have a database with a single associated user account that owns the database. 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 in a table (unrelated to those being modified through the first connection) 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?
Sounds to me like your "second persistent connection" is the same
connection. Better re-read the PHP docs ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Yarra | 2003-03-19 23:10:31 | Re: [BUGS] Bug #904: Deallocating of prepared statement in ECPG at |
Previous Message | Philippe Hajjar | 2003-03-19 21:57:15 | Possible bug with regards to multiple persistant connections |