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