Skip to content

duplicate-unique-key-column (CT006)#

Automatic fix is available.

What it does#

Checks for duplicate column in unique key constraint.

Why not?#

While PostgreSQL does not allow duplicate columns in a unique key constraint, such constructs are still parseable, but will error out at runtime.

Having a duplicate column in a unique key constraint is an obvious error.

When should you?#

Never.

Use instead:#

Remove duplicate column from the unique key constraint.