# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1481731584 -3600
# Node ID ec29989fba1352dc2e08e116d3698bbbf5c2304f
# Parent  b230f4a4010dd8afe25729b5b94f2ae100815183
Enhance postgres index filter with values from real life

This has been found on fairly old instances of ours (cwo/elo). Dunno if we
really want this in, it may lead to false negatives.

diff -r b230f4a4010d -r ec29989fba13 cubicweb/server/checkintegrity.py
--- a/cubicweb/server/checkintegrity.py	Wed Dec 14 17:04:29 2016 +0100
+++ b/cubicweb/server/checkintegrity.py	Wed Dec 14 17:06:24 2016 +0100
@@ -481,7 +481,8 @@
     if source.dbdriver == 'postgres':
 
         def index_filter(idx):
-            return not (idx.startswith('pg_') or idx.endswith('_pkey'))
+            return not (idx.startswith('pg_') or '_pkey' in idx or '_p_key' in idx
+                        or idx.endswith('_key'))
     else:
 
         def index_filter(idx):