Ryan Ho <ryanho(at)cyberronins(dot)com> writes:
> In a transaction, should any of the sql statements fail to execute, does Postgres rollback all the previous statements?
Yes.
> To my best knowledge, it should but I have observed that on some occasions, half my transaction can get committed, while the other half is unsuccessful.
Hard to believe. Can you provide some evidence?
regards, tom lane