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
>
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
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
Hello everyone!
eugene@dignus:/var/www/html/health$ psql xbox
Timing is on.
psql (12.3 (Ubuntu 12.3-1.pgdg20.04+1))
Type "help" for help.
xbox=> \d herostat
Table "public.herostat"
Column | Type | Collation | Nullable | Default
--+--+-
