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

2020-06-16 Thread Eugene Pazhitnov
Ok, thanks a lot! Got it. вт, 16 июн. 2020 г. в 17:12, Tom Lane : > Eugene Pazhitnov writes: > > xbox=> \d herostat > > ... > > "herostat_pkey" PRIMARY KEY, btree (xuid, titleid, heroid) INCLUDE > (valfloat) > > > eugene@dignus:/var/www/html/health$ sudo -u postgres pg_repack -t > herostat >

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

2020-06-16 Thread Tom Lane
Eugene Pazhitnov writes: > xbox=> \d herostat > ... > "herostat_pkey" PRIMARY KEY, btree (xuid, titleid, heroid) INCLUDE > (valfloat) > eugene@dignus:/var/www/html/health$ sudo -u postgres pg_repack -t herostat > -N -d xbox > INFO: Dry run enabled, not executing repack > WARNING: relation "p

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

2020-06-16 Thread Michael Lewis
On Tue, Jun 16, 2020, 4:52 AM Eugene Pazhitnov 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 > un