Re: pg_repack: WARNING: relation must have a primary key or not-null unique keys

[Michael Lewis <mlewis@xxxxxxxxxxx>]

On Tue, Jun 16, 2020, 4:52 AM Eugene Pazhitnov <pazhitnov@xxxxxxxxx> wrote:

xbox=> \d herostat
                   Table "public.herostat"
Indexes:
    "herostat_pkey" PRIMARY KEY, btree (xuid, titleid, heroid) INCLUDE (valfloat)

WARNING: relation "public.herostat" must have a primary key or not-null unique keys 

What is wrong and what I can do to fix it?

I don't know, but I would guess that the "include" option is not supported by pg_repack.