Re: Remove obsolete information schema tables

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Remove obsolete information schema tables
Дата
Msg-id 20191017074419.GE17439@paquier.xyz
обсуждение исходный текст
Ответ на Remove obsolete information schema tables  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: Remove obsolete information schema tables  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Proposal: Make use of C99 designated initialisers fornulls/values arrays
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Remaining calls of heap_close/heap_open in the tree