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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: pg_repack: WARNING: relation must have a primary key or not-nullunique keys
Дата
Msg-id CAHOFxGqX1XKJmYnUXH5KA1up-8pk8bH9yzc5+_9Y+Kg9ZFcv6Q@mail.gmail.com
обсуждение исходный текст
Ответ на pg_repack: WARNING: relation must have a primary key or not-nullunique keys  (Eugene Pazhitnov <pazhitnov@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Something else about Redo Logs disappearing
Следующее
От: Susan Joseph
Дата:
Сообщение: Minor Upgrade Question