Hi, On 2020-10-03 08:40:31 +0200, Peter Eisentraut wrote: > Since we have ADD PRIMARY KEY USING INDEX, we can declare a primary key for > an existing index. So this doesn't have to affect the low-level early > bootstrapping. The attached patch adds those commands manually. Another > option might be to have the catalog generation Perl tooling create those > declarations automatically from some marker in the catalog files. That > would also allow declaring unique constraints for the unique indexes that > don't end up being the primary key.
Hm. What prevents us from declaring the pkey during bootstrap? I don't at all like adding yet another place that needs manual editing when doing DDL changes. Greetings, Andres Freund