diff options
Diffstat (limited to 'gems/gitlab-schema-validation/lib/gitlab/schema/validation/sources/database.rb')
-rw-r--r-- | gems/gitlab-schema-validation/lib/gitlab/schema/validation/sources/database.rb | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/gems/gitlab-schema-validation/lib/gitlab/schema/validation/sources/database.rb b/gems/gitlab-schema-validation/lib/gitlab/schema/validation/sources/database.rb index 45ce4d8ebfe..3f62396c156 100644 --- a/gems/gitlab-schema-validation/lib/gitlab/schema/validation/sources/database.rb +++ b/gems/gitlab-schema-validation/lib/gitlab/schema/validation/sources/database.rb @@ -143,8 +143,10 @@ module Gitlab # rubocop:disable Rails/SquishedSQLHeredocs sql = <<~SQL SELECT indexname, indexdef - FROM pg_indexes - WHERE indexname NOT LIKE '%_pkey' AND schemaname IN ($1, $2); + FROM pg_indexes i + LEFT JOIN pg_constraint AS c ON i.indexname = c.conname + WHERE i.indexname NOT LIKE '%_pkey' AND schemaname IN ($1, $2) + AND c.conname IS NULL; SQL # rubocop:enable Rails/SquishedSQLHeredocs |