[Mailman-Developers] Unable to commit changes from mailman shell to database

[Barry Warsaw]

On Apr 03, 2016, at 01:30 AM, Gurkirpal Singh wrote:

>Maybe it was there because I'm using PostgreSQL but it worked for me.

Cool, so it's working now?

I believe SQLAlchemy opens a transaction automatically, so that the bound
commit() and abort() methods operate on that transaction.  By creating a new
connection and a new transaction, I think you might have created a
subtransaction which didn't get flushed to the database.  It probably doesn't
have anything to do with the db backend specifically, but just how SA works.

Cheers,
-Barry