Re: More on my partitioning problem

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