PgBouncer pooling modes: why can transaction pooling break some apps?

Answer

In transaction pooling, PgBouncer can switch the underlying DB connection between transactions. That means session state (temp tables, session variables, prepared statements) may not persist. Apps that assume a stable session can break; you may need session pooling or avoid session state.