On 21/11/2018 09:20, Christoph Berg wrote: > Re: Andres Freund 2018-11-21 <e1gpg3j-0003cy...@gemulon.postgresql.org> >> The biggest user of WITH OID columns was postgres' catalog. This >> commit changes all 'magic' oid columns to be columns that are normally >> declared and stored. > > postgres=# \d+ pg_class > [...] > Indexe: > "pg_class_oid_index" UNIQUE, btree (oid) > > Now that oid is a proper column, shouldn't that be a PRIMARY KEY? > (Just for the looks.)
This is an independent consideration. There was nothing before that prevented an index on an oid column from being a primary key that isn't still there. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
