Top "Database-integrity" questions

IntegrityError duplicate key value violates unique constraint - django/postgres

I'm following up in regards to a question that I asked earlier in which I sought to seek a conversion …

django postgresql duplicates unique-constraint database-integrity
"SET FOREIGN_KEY_CHECKS = 0;" Oracle Equivalent

Is there some equivalent to the Mysql specific instruction that disable the check of the foreign keys constraints ? SET FOREIGN_…

oracle key database-integrity
Are there any difference between data integrity and data consistency?

I'm a little confused about data consistency and data integrity. From Oracle Database Concepts: data integrity -------------- Business rules that …

database transactions database-integrity data-consistency
How to check MySQL integrity?

I have a big MySQL 5 Database for a drupal site on an old machine. After backing up and restoring on …

mysql database-integrity
SQL Server: How to make server check all its check constraints?

It seems that some scripts generated by Enterprise Manager* (or not, it doesn't matter) created check constraints WITH NOCHECK. Now …

sql-server sql-server-2000 check-constraints database-integrity sp-msforeachtable
Rails 3: Validate combined values

In Rails 2.x you can use validations to make sure you have a unique combined value like this: validates_uniqueness_…

ruby-on-rails ruby-on-rails-3 validation validates-uniqueness-of database-integrity