On 12/22/2017 07:01 PM, rihad wrote:
> [snip]
> foo=# select bt_index_check('index_users_on_email_and_type');
> ERROR: item order invariant violated for index
> "index_users_on_email_and_type"
> DETAIL: Lower index tid=(3,25) (points to index tid=(26,1)) higher
> index tid=(3,26) (points to index tid=(27,1)) page lsn=0/0.
>
Interestingly, another (varchar,varchar) index on a completely different
table doesn't have the problem because it probably doesn't contain any
non-ascii symbols.
gateway_reference | character varying(255) | | |
gateway_name | character varying | | |
foo=# select
bt_index_check('index_transactions_on_gateway_name_and_gateway_reference');
bt_index_check
----------------
(1 row)