Thank, Laurenz ( again ) don’t know why I didn’t think of that. 😎 Sent from my iPad > On Nov 2, 2020, at 9:34 AM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: > > 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 >
