[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
