SDB804[critical]Execution evidence
Statement failed
PostgreSQL returned an error while executing the migration.
Why it's risky in PostgreSQL
The migration failed on the verification database. It will most likely fail the same way in production.
What triggers it, and the safer way
ALTER TABLE users ADD CONSTRAINT users_email_key UNIQUE (email); -- duplicates exist-- Fix the data first, or change the migration.Suppress it when you're sure
Put this comment on the line before the statement. The reason is required and shows in the report.
-- shadowdb:allow SDB804 <why this is safe here>Applies to PostgreSQL 14, 15, 16, 17.