> On Jun 20, 2014, at 10:01 AM, Tom Lane <t...@sss.pgh.pa.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers