Re: Remove obsolete information schema tables - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Remove obsolete information schema tables
Date
Msg-id 20191017074419.GE17439@paquier.xyz
Whole thread Raw
In response to Remove obsolete information schema tables  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Remove obsolete information schema tables
List 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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Proposal: Make use of C99 designated initialisers fornulls/values arrays
Next
From: Andres Freund
Date:
Subject: Re: Remaining calls of heap_close/heap_open in the tree