zmień kontrast font size: A A A
rss polski
you are at >> basics >>transactions

Transactions

General

It is a collection of operations on the database, which form one whole. They should all be done or none of them. There can't be done partially. Terms of the transactions are more accurately described in terms of ACID.
In this course will be presented PostgreSQL transactions . In this language transactions are described by 3 phrases:

ACID

ACID defines terms which transaction has to meet.

Anomalies

Isolation levels

Below are following levels of isolation of transaction
READ COMMITTED is a default mode
Isolation level can be set by syntax given below:
    
set transaction isolaction level { isolation_level_name }
    
    
[ wróć na górę strony ]