469,955 Members | 2,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,955 developers. It's quick & easy.

PostgreSQL and ACID properties support


I would like to know to what extent PostgreSQL includes support for the ACID
properties of transactions (Atomicity, Consistency, Isolation, and Durability).
In particular, does PostgreSQL include constructs to guarantee that a sequence
of SQL statements is executed atomically (i.e., either all execute to completion
or none of them do). Also, with regards to isolation, what is the status of
PostgreSQL's implementation with respect to providing the option of concurrency
of transactions as opposed to the operations taking place serially? Also, does
PostgreSQL fully support SQL99 CHECK constraints? And if the system crashes...
is the database guaranteed to remain in a consistent state?


Nov 11 '05 #1
0 1170

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

33 posts views Thread by Joshua D. Drake | last post: by
29 posts views Thread by Paul Ganainm | last post: by
59 posts views Thread by Jeff Bowden | last post: by
6 posts views Thread by Abandoned | last post: by
reply views Thread by krithika.143 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.