Ryan Ho <ryanho@cyberronins.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,
whilethe other half is unsuccessful.
Hard to believe. Can you provide some evidence?
regards, tom lane