[prev] 42 [next]

Transaction Terminology (cont)

More on transactions and SQL
  • BEGIN starts a transaction
    • the begin keyword in PLpgSQL is not the same thing
  • COMMIT commits and ends the current transaction
    • some DBMSs e.g. PostgreSQL also provide END as a synonym
    • the end keyword in PLpgSQL is not the same thing
  • ROLLBACK aborts the current transaction, undoing any changes
    • some DBMSs e.g. PostgreSQL also provide ABORT as a synonym
In PostgreSQL, tx's cannot be defined inside functions (e.g. PLpgSQL)