PostgreSQL provides data consistency checks at the application level using Read Committed transactions and explicit blocking locks.
Global validity checks are also necessary to ensure data integrity.
SELECT FOR UPDATE, SELECT FOR SHARE, or an appropriate LOCK TABLE statement can be used to protect against concurrent updates.
See more results on Neeva
Summaries from the best pages on the web
PostgreSQL , also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.
PostgreSQL - Wikipedia
PostgreSQL is a database management system that allows users to enforce business rules regarding data integrity using Read Committed transactions. Serializable transactions are used to ensure consistency with explicit blocking locks, and SELECT FOR UPDATE, SELECT FOR SHARE, or an appropriate LOCK TABLE statement can be used to protect against concurrent updates. Global validity checks require extra thought under non-serializable MVCC, and global validity checks must be used to ensure the sum of all credits in one table equals the sum of debits in another table.
PostgreSQL: Documentation: 15: 13.4. Data Consistency Checks at the Application Level