But the rule is, if any query within the transaction errors, then all querieswithin the transaction are rolled back.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных