Re: Typo in misc_sanity.sql?

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Japin Li <japinli(at)hotmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Typo in misc_sanity.sql?
Date: 2022-08-10 11:49:24
Message-ID: 44c52e03-d478-2a00-42e3-b6e106e232d4@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 25.07.22 14:04, Japin Li wrote:
> Yeah, they do not have unique keys, however, here we check primary keys. So,
> IMO, the description exceptions should say they do not have primary keys,
> rather than do not have unique keys.

The context of that check is that for each system catalog we pick one of
the available unique keys and designate it as the one primary key. If a
system catalog doesn't have a unique key to choose from, then we can't
do that, hence the comment. Changing the comment as suggested would
essentially be saying, this catalog has no primary key because it has no
primary key, which wouldn't be helpful.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Drouvot, Bertrand 2022-08-10 12:02:34 Re: shared-memory based stats collector - v70
Previous Message John Naylor 2022-08-10 10:57:46 Re: NAMEDATALEN increase because of non-latin languages