Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_repack: WARNING: relation must have a primary key or not-nullunique keys - Mailing list pgsql-general

From Michael Lewis
Subject Re: pg_repack: WARNING: relation must have a primary key or not-nullunique keys
Date
Msg-id CAHOFxGqX1XKJmYnUXH5KA1up-8pk8bH9yzc5+_9Y+Kg9ZFcv6Q@mail.gmail.com
Whole thread Raw
In response to pg_repack: WARNING: relation must have a primary key or not-nullunique keys  (Eugene Pazhitnov <pazhitnov@gmail.com>)
List pgsql-general
Tree view
On Tue, Jun 16, 2020, 4:52 AM Eugene Pazhitnov <pazhitnov@gmail.com> 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. 

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Something else about Redo Logs disappearing
Next
From: Susan Joseph
Date:
Subject: Minor Upgrade Question