Re: Remove obsolete information schema tables

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Remove obsolete information schema tables
Date: 2019-10-17 07:44:19
Message-ID: 20191017074419.GE17439@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 14, 2019 at 10:27:14AM +0200, Peter Eisentraut wrote:
> I propose this patch to remove the information schema tables
> SQL_LANGUAGES, which was eliminated in SQL:2008, and SQL_PACKAGES, which
> was eliminated in SQL:2011. Since they were dropped by the SQL
> standard, the information in them was no longer updated and therefore no
> longer useful.

The cleanup looks right. I cannot grep missing references FWIW.

> This also removes the feature-package association information in
> sql_feature_packages.txt, but for the time begin we are keeping the
> information which features are in the Core package (that is, mandatory
> SQL features). Maybe at some point someone wants to invent a way to
> store that that does not involve using the "package" mechanism
> anymore.

I have a question here. Per the notes in information_schema.sql,
SQL_SIZING_PROFILES has been removed in SQL:2011,
attributes.isnullable and DOMAIN_UDT_USAGE in SQL:2003~. Would it
make sense to cleanup those ones?
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-10-17 08:04:50 Re: Remaining calls of heap_close/heap_open in the tree
Previous Message Michael Paquier 2019-10-17 07:30:02 Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays