psql -X 2>&1 <<'SQL'
BEGIN;
UPDATE rekening SET saldo = saldo - 50000 WHERE id = 1;
UPDATE rekening SET saldo = saldo + 50000 WHERE id = 2;
SAVEPOINT sebelum_notifikasi;
INSERT INTO notifikasi (rekening_id, kanal, pesan) VALUES (1, 'whatsapp', 'Transfer Rp50000 ke Siti Aminah');
ROLLBACK TO SAVEPOINT sebelum_notifikasi;
INSERT INTO notifikasi (rekening_id, kanal, pesan) VALUES (1, 'sms', 'Transfer Rp50000 ke Siti Aminah');
COMMIT;
SELECT id, rekening_id, kanal, pesan FROM notifikasi ORDER BY id;
SELECT id, nama, saldo FROM rekening WHERE id IN (1, 2) ORDER BY id;
SQL