03 Jun 2022
A user defined function that fires automatically when an event (insert, update, delete, truncate) occurs.
A single unit of work that consists of one or more operations.
→ Ensures operations are completed, otherwise transaction is aborted
BEGIN TRANSACTION; / or BEGIN;
CREATE TABLE test(n int)
INSERT INTO test values(1)
END TRANSACTION; / or COMMIT;
ROLLBACK - a command that reverts changes, run before COMMIT
Allows information on the primary server to be transferred to the standby server in real time.