By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,781 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,781 IT Pros & Developers. It's quick & easy.

PostgreSQL and ACID properties support

P: n/a
Hello,

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?

Thanks,

Neil
Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.