Is it true that the current version of PostgreSQL does always respectatomicity of transactions and MySQL does not?