pgsql-bugs@postgresql.org writes:
> I have a database with a single associated user account that owns the database. I connect using a to this database
andbegin a transaction and start doing inserts and updates. However, I want to commit some other data to the same
databasein a table (unrelated to those being modified through the first connection) outside of the transaction so I
opena second persistant connection under the same user account and I write this information using an INSERT. In the
firstconnection, I roll back the transaction and the insert I did under the second connection also gets rolled back.
Isthis supposed to occur?
Sounds to me like your "second persistent connection" is the same
connection. Better re-read the PHP docs ...
regards, tom lane