> On Jun 20, 2014, at 10:01 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Some of my Salesforce colleagues are looking into making every system
> catalog be declared with a true primary key. They came across the
> fact that pg_seclabel and pg_shseclabel are declared with unique
> indexes that include the "provider" column, but that column does not
> get marked as NOT NULL during initdb. Shouldn't it be?
At some point, I inferred a rule that catalog columns were intended to be either both fixed-width and not nullable; or variable-width and nullable. I believe the current situation is the result of that inference... but I see no particular reason not to change it.
...Robert