Set correct default transaction type in PostgreSQL.