pg_constraint.conincluding is useless

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>
Subject: pg_constraint.conincluding is useless
Date: 2018-09-02 16:50:18
Message-ID: 20180902165018.33otxftp3olgtu4t@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

Already mentioned this in
https://postgr.es/m/20180831205020.nxhw6ypysgshjtnl@alvherre.pgsql

While trying to add support for foreign keys to partitioned tables, I
noticed that commit 8224de4f42cc ("Indexes with INCLUDE columns and
their support in B-tree") added a column to pg_constraint that appears
to be there only to enable ruleutils.c to print out the list of columns
in a PRIMARY KEY or UNIQUE constraint that uses included columns.
However, this is pretty easy to obtain from pg_index.conkey instead, so
I claim that that column is useless. In fact, here's a patch to remove
it.

This requires a catversion bump, for which it may seem a bit late;
however I think it's better to release pg11 without a useless catalog
column only to remove it in pg12 ...

Thoughts?

--
Álvaro Herrera

Attachment Content-Type Size
0001-remove-conincluding.patch text/plain 15.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-09-02 17:27:25 Re: pg_constraint.conincluding is useless
Previous Message Fabien COELHO 2018-09-02 16:27:29 Re[3]: Adding a note to protocol.sgml regarding CopyData