On Mon, 2020-11-02 at 07:40 -0500, John Scalia wrote: > I created a UNIQUE INDEX on the new base table using the original primary key > and the partitioning key. So far, so good. But doing an ALTER TABLE ADD PRIMARY KEY USING INDEX, > is not supported. So. being that I already have a unique index here, does it > really matter if I do not declare a primary key here? Otherwise, how would I go > about creating a primary key on this partitioned table? Don't create a unique index and then use it to define a primary key constraint, create the primary key directly: ALTER TABLE part ADD PRIMARY KEY (id, part_key); Yours, Laurenz -- Cybertec | https://www.cybertec-postgresql.com
