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
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 |