[PostgreSQL] Transaction + Pool 사용시 주의
·
DataBase/PostgreSQL
pool 객체를 트랜잭션과 함께 쓰지마라. Do not use pool.query if you need transactional integrity: the pool will dispatch every query passed to pool.query on the first available idle client. Transactions within PostgreSQL are scoped to a single client and so dispatching individual queries within a single transaction across multiple, random clients will cause big problems in your app and not work. For more info ..