Horton

Change the relkind for partitioned tables from 'P' to 'p'.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 8b358b42f8eb6156a82ac9a41fc4e8335c8dc37a
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2017-03-10T18:15:47Z
Releases: 10.0 
Change the relkind for partitioned tables from 'P' to 'p'.

Seven of the eight other relkind codes are lower-case, so it wasn't
consistent for this one to be upper-case.  Fix it while we still can.

Historical notes: the reason for the lone exception, i.e. sequences being
'S', is that 's' was once used for "special" relations.  Also, at one time
the partitioned-tables patch used both 'P' and 'p', but that got changed,
leaving only a surprising choice behind.

This also fixes a couple little bits of technical debt, such as
type_sanity.sql not knowing that 'm' is a legal value for relkind.

Discussion: https://postgr.es/m/27899.1488909319@sss.pgh.pa.us

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +8 −5
src/backend/catalog/information_schema.sql modified +23 −21
src/backend/catalog/system_views.sql modified +2 −2
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_class.h modified +6 −5
src/test/regress/expected/create_table.out modified +1 −1
src/test/regress/expected/rules.out modified +2 −2
src/test/regress/expected/sanity_check.out modified +1 −1
src/test/regress/expected/type_sanity.out modified +1 −1
src/test/regress/sql/sanity_check.sql modified +1 −1
src/test/regress/sql/type_sanity.sql modified +1 −1

Documentation touched

Discussion