Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2fc2a88

Browse files
committed
Remove obsolete information schema tables
Remove SQL_LANGUAGES, which was eliminated in SQL:2008, andSQL_PACKAGES and SQL_SIZING_PROFILES, which were eliminated inSQL:2011. Since they were dropped by the SQL standard, theinformation in them was no longer updated and therefore no longeruseful.This also removes the feature-package association information insql_feature_packages.txt, but for the time begin we are keeping theinformation which features are in the Core package (that is, mandatorySQL features). Maybe at some point someone wants to invent a way tostore that that does not involve using the "package" mechanismanymore.Discussionhttps://www.postgresql.org/message-id/flat/91334220-7900-071b-9327-0c6ecd012017%402ndquadrant.com
1 parent592a163 commit2fc2a88

File tree

7 files changed

+4
-329
lines changed

7 files changed

+4
-329
lines changed

‎doc/src/sgml/features.sgml

Lines changed: 3 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -44,10 +44,7 @@
4444
broad three levels found in <acronym>SQL-92</acronym>. A large
4545
subset of these features represents the <quote>Core</quote>
4646
features, which every conforming SQL implementation must supply.
47-
The rest of the features are purely optional. Some optional
48-
features are grouped together to form <quote>packages</quote>, which
49-
SQL implementations can claim conformance to, thus claiming
50-
conformance to particular groups of features.
47+
The rest of the features are purely optional.
5148
</para>
5249

5350
<para>
@@ -116,7 +113,7 @@
116113
<thead>
117114
<row>
118115
<entry>Identifier</entry>
119-
<entry>Package</entry>
116+
<entry>Core?</entry>
120117
<entry>Description</entry>
121118
<entry>Comment</entry>
122119
</row>
@@ -143,7 +140,7 @@
143140
<thead>
144141
<row>
145142
<entry>Identifier</entry>
146-
<entry>Package</entry>
143+
<entry>Core?</entry>
147144
<entry>Description</entry>
148145
<entry>Comment</entry>
149146
</row>

‎doc/src/sgml/information_schema.sgml

Lines changed: 0 additions & 216 deletions
Original file line numberDiff line numberDiff line change
@@ -4963,160 +4963,6 @@ ORDER BY c.ordinal_position;
49634963
</table>
49644964
</sect1>
49654965

4966-
<sect1 id="infoschema-sql-languages">
4967-
<title><literal>sql_languages</literal></title>
4968-
4969-
<para>
4970-
The table <literal>sql_languages</literal> contains one row for
4971-
each SQL language binding that is supported by
4972-
<productname>PostgreSQL</productname>.
4973-
<productname>PostgreSQL</productname> supports direct SQL and
4974-
embedded SQL in C; that is all you will learn from this table.
4975-
</para>
4976-
4977-
<para>
4978-
This table was removed from the SQL standard in SQL:2008, so there
4979-
are no entries referring to standards later than SQL:2003.
4980-
</para>
4981-
4982-
<table>
4983-
<title><literal>sql_languages</literal> Columns</title>
4984-
4985-
<tgroup cols="3">
4986-
<thead>
4987-
<row>
4988-
<entry>Name</entry>
4989-
<entry>Data Type</entry>
4990-
<entry>Description</entry>
4991-
</row>
4992-
</thead>
4993-
4994-
<tbody>
4995-
<row>
4996-
<entry><literal>sql_language_source</literal></entry>
4997-
<entry><type>character_data</type></entry>
4998-
<entry>
4999-
The name of the source of the language definition; always
5000-
<literal>ISO 9075</literal>, that is, the SQL standard
5001-
</entry>
5002-
</row>
5003-
5004-
<row>
5005-
<entry><literal>sql_language_year</literal></entry>
5006-
<entry><type>character_data</type></entry>
5007-
<entry>
5008-
The year the standard referenced in
5009-
<literal>sql_language_source</literal> was approved.
5010-
</entry>
5011-
</row>
5012-
5013-
<row>
5014-
<entry><literal>sql_language_conformance</literal></entry>
5015-
<entry><type>character_data</type></entry>
5016-
<entry>
5017-
The standard conformance level for the language binding. For
5018-
ISO 9075:2003 this is always <literal>CORE</literal>.
5019-
</entry>
5020-
</row>
5021-
5022-
<row>
5023-
<entry><literal>sql_language_integrity</literal></entry>
5024-
<entry><type>character_data</type></entry>
5025-
<entry>Always null (This value is relevant to an earlier version of the SQL standard.)</entry>
5026-
</row>
5027-
5028-
<row>
5029-
<entry><literal>sql_language_implementation</literal></entry>
5030-
<entry><type>character_data</type></entry>
5031-
<entry>Always null</entry>
5032-
</row>
5033-
5034-
<row>
5035-
<entry><literal>sql_language_binding_style</literal></entry>
5036-
<entry><type>character_data</type></entry>
5037-
<entry>
5038-
The language binding style, either <literal>DIRECT</literal> or
5039-
<literal>EMBEDDED</literal>
5040-
</entry>
5041-
</row>
5042-
5043-
<row>
5044-
<entry><literal>sql_language_programming_language</literal></entry>
5045-
<entry><type>character_data</type></entry>
5046-
<entry>
5047-
The programming language, if the binding style is
5048-
<literal>EMBEDDED</literal>, else null. <productname>PostgreSQL</productname> only
5049-
supports the language C.
5050-
</entry>
5051-
</row>
5052-
</tbody>
5053-
</tgroup>
5054-
</table>
5055-
</sect1>
5056-
5057-
<sect1 id="infoschema-sql-packages">
5058-
<title><literal>sql_packages</literal></title>
5059-
5060-
<para>
5061-
The table <literal>sql_packages</literal> contains information
5062-
about which feature packages defined in the SQL standard are
5063-
supported by <productname>PostgreSQL</productname>. Refer to <xref
5064-
linkend="features"/> for background information on feature packages.
5065-
</para>
5066-
5067-
<table>
5068-
<title><literal>sql_packages</literal> Columns</title>
5069-
5070-
<tgroup cols="3">
5071-
<thead>
5072-
<row>
5073-
<entry>Name</entry>
5074-
<entry>Data Type</entry>
5075-
<entry>Description</entry>
5076-
</row>
5077-
</thead>
5078-
5079-
<tbody>
5080-
<row>
5081-
<entry><literal>feature_id</literal></entry>
5082-
<entry><type>character_data</type></entry>
5083-
<entry>Identifier string of the package</entry>
5084-
</row>
5085-
5086-
<row>
5087-
<entry><literal>feature_name</literal></entry>
5088-
<entry><type>character_data</type></entry>
5089-
<entry>Descriptive name of the package</entry>
5090-
</row>
5091-
5092-
<row>
5093-
<entry><literal>is_supported</literal></entry>
5094-
<entry><type>yes_or_no</type></entry>
5095-
<entry>
5096-
<literal>YES</literal> if the package is fully supported by the
5097-
current version of <productname>PostgreSQL</productname>, <literal>NO</literal> if not
5098-
</entry>
5099-
</row>
5100-
5101-
<row>
5102-
<entry><literal>is_verified_by</literal></entry>
5103-
<entry><type>character_data</type></entry>
5104-
<entry>
5105-
Always null, since the <productname>PostgreSQL</productname> development group does not
5106-
perform formal testing of feature conformance
5107-
</entry>
5108-
</row>
5109-
5110-
<row>
5111-
<entry><literal>comments</literal></entry>
5112-
<entry><type>character_data</type></entry>
5113-
<entry>Possibly a comment about the supported status of the package</entry>
5114-
</row>
5115-
</tbody>
5116-
</tgroup>
5117-
</table>
5118-
</sect1>
5119-
51204966
<sect1 id="infoschema-sql-parts">
51214967
<title><literal>sql_parts</literal></title>
51224968

@@ -5239,68 +5085,6 @@ ORDER BY c.ordinal_position;
52395085
</table>
52405086
</sect1>
52415087

5242-
<sect1 id="infoschema-sql-sizing-profiles">
5243-
<title><literal>sql_sizing_profiles</literal></title>
5244-
5245-
<para>
5246-
The table <literal>sql_sizing_profiles</literal> contains
5247-
information about the <literal>sql_sizing</literal> values that are
5248-
required by various profiles of the SQL standard. <productname>PostgreSQL</productname> does
5249-
not track any SQL profiles, so this table is empty.
5250-
</para>
5251-
5252-
<table>
5253-
<title><literal>sql_sizing_profiles</literal> Columns</title>
5254-
5255-
<tgroup cols="3">
5256-
<thead>
5257-
<row>
5258-
<entry>Name</entry>
5259-
<entry>Data Type</entry>
5260-
<entry>Description</entry>
5261-
</row>
5262-
</thead>
5263-
5264-
<tbody>
5265-
<row>
5266-
<entry><literal>sizing_id</literal></entry>
5267-
<entry><type>cardinal_number</type></entry>
5268-
<entry>Identifier of the sizing item</entry>
5269-
</row>
5270-
5271-
<row>
5272-
<entry><literal>sizing_name</literal></entry>
5273-
<entry><type>character_data</type></entry>
5274-
<entry>Descriptive name of the sizing item</entry>
5275-
</row>
5276-
5277-
<row>
5278-
<entry><literal>profile_id</literal></entry>
5279-
<entry><type>character_data</type></entry>
5280-
<entry>Identifier string of a profile</entry>
5281-
</row>
5282-
5283-
<row>
5284-
<entry><literal>required_value</literal></entry>
5285-
<entry><type>cardinal_number</type></entry>
5286-
<entry>
5287-
The value required by the SQL profile for the sizing item, or 0
5288-
if the profile places no limit on the sizing item, or null if
5289-
the profile does not require any of the features for which the
5290-
sizing item is applicable
5291-
</entry>
5292-
</row>
5293-
5294-
<row>
5295-
<entry><literal>comments</literal></entry>
5296-
<entry><type>character_data</type></entry>
5297-
<entry>Possibly a comment pertaining to the sizing item within the profile</entry>
5298-
</row>
5299-
</tbody>
5300-
</tgroup>
5301-
</table>
5302-
</sect1>
5303-
53045088
<sect1 id="infoschema-table-constraints">
53055089
<title><literal>table_constraints</literal></title>
53065090

‎src/backend/catalog/information_schema.sql

Lines changed: 0 additions & 70 deletions
Original file line numberDiff line numberDiff line change
@@ -1648,56 +1648,6 @@ INSERT INTO sql_implementation_info VALUES ('46', 'TRANSACTION CAPABLE', 2, N
16481648
GRANTSELECTON sql_implementation_info TO PUBLIC;
16491649

16501650

1651-
/*
1652-
* SQL_LANGUAGES table
1653-
* apparently removed in SQL:2008
1654-
*/
1655-
1656-
CREATETABLEsql_languages (
1657-
sql_language_source character_data,
1658-
sql_language_year character_data,
1659-
sql_language_conformance character_data,
1660-
sql_language_integrity character_data,
1661-
sql_language_implementation character_data,
1662-
sql_language_binding_style character_data,
1663-
sql_language_programming_language character_data
1664-
);
1665-
1666-
INSERT INTO sql_languagesVALUES ('ISO 9075','1999','CORE',NULL,NULL,'DIRECT',NULL);
1667-
INSERT INTO sql_languagesVALUES ('ISO 9075','1999','CORE',NULL,NULL,'EMBEDDED','C');
1668-
INSERT INTO sql_languagesVALUES ('ISO 9075','2003','CORE',NULL,NULL,'DIRECT',NULL);
1669-
INSERT INTO sql_languagesVALUES ('ISO 9075','2003','CORE',NULL,NULL,'EMBEDDED','C');
1670-
1671-
GRANTSELECTON sql_languages TO PUBLIC;
1672-
1673-
1674-
/*
1675-
* SQL_PACKAGES table
1676-
* removed in SQL:2011
1677-
*/
1678-
1679-
CREATETABLEsql_packages (
1680-
feature_id character_data,
1681-
feature_name character_data,
1682-
is_supported yes_or_no,
1683-
is_verified_by character_data,
1684-
comments character_data
1685-
);
1686-
1687-
INSERT INTO sql_packagesVALUES ('PKG000','Core','NO',NULL,'');
1688-
INSERT INTO sql_packagesVALUES ('PKG001','Enhanced datetime facilities','YES',NULL,'');
1689-
INSERT INTO sql_packagesVALUES ('PKG002','Enhanced integrity management','NO',NULL,'');
1690-
INSERT INTO sql_packagesVALUES ('PKG003','OLAP facilities','NO',NULL,'');
1691-
INSERT INTO sql_packagesVALUES ('PKG004','PSM','NO',NULL,'PL/pgSQL is similar.');
1692-
INSERT INTO sql_packagesVALUES ('PKG005','CLI','NO',NULL,'ODBC is similar.');
1693-
INSERT INTO sql_packagesVALUES ('PKG006','Basic object support','NO',NULL,'');
1694-
INSERT INTO sql_packagesVALUES ('PKG007','Enhanced object support','NO',NULL,'');
1695-
INSERT INTO sql_packagesVALUES ('PKG008','Active database','NO',NULL,'');
1696-
INSERT INTO sql_packagesVALUES ('PKG010','OLAP','NO',NULL,'NO');
1697-
1698-
GRANTSELECTON sql_packages TO PUBLIC;
1699-
1700-
17011651
/*
17021652
* 5.59
17031653
* SQL_PARTS table
@@ -1768,26 +1718,6 @@ UPDATE sql_sizing
17681718
GRANTSELECTON sql_sizing TO PUBLIC;
17691719

17701720

1771-
/*
1772-
* SQL_SIZING_PROFILES table
1773-
* removed in SQL:2011
1774-
*/
1775-
1776-
-- The data in this table are defined by various profiles of SQL.
1777-
-- Since we don't have any information about such profiles, we provide
1778-
-- an empty table.
1779-
1780-
CREATETABLEsql_sizing_profiles (
1781-
sizing_id cardinal_number,
1782-
sizing_name character_data,
1783-
profile_id character_data,
1784-
required_value cardinal_number,
1785-
comments character_data
1786-
);
1787-
1788-
GRANTSELECTON sql_sizing_profiles TO PUBLIC;
1789-
1790-
17911721
/*
17921722
* 5.61
17931723
* TABLE_CONSTRAINTS view

‎src/backend/catalog/sql_feature_packages.txt

Lines changed: 0 additions & 29 deletions
Original file line numberDiff line numberDiff line change
@@ -22,46 +22,17 @@ F021Core
2222
F031Core
2323
F041Core
2424
F051Core
25-
F052Enhanced datetime facilities
2625
F081Core
2726
F131Core
2827
F181Core
29-
F191Enhanced integrity management
3028
F201Core
3129
F221Core
3230
F261Core
3331
F311Core
34-
F411Enhanced datetime facilities
3532
F471Core
3633
F481Core
37-
F491Enhanced integrity management
3834
F501Core
39-
F521Enhanced integrity management
40-
F555Enhanced datetime facilities
41-
F671Enhanced integrity management
42-
F701Enhanced integrity management
4335
F812Core
4436
S011Core
45-
S023Basic object support
46-
S024Enhanced object support
47-
S041Basic object support
48-
S043Enhanced object support
49-
S051Basic object support
50-
S071Enhanced object support
51-
S081Enhanced object support
52-
S111Enhanced object support
53-
S151Basic object support
54-
S161Enhanced object support
55-
S211Enhanced object support
56-
S231Enhanced object support
57-
T041Basic object support
58-
T191Enhanced integrity management
59-
T201Enhanced integrity management
60-
T211Active database
61-
T211Enhanced integrity management
62-
T212Enhanced integrity management
6337
T321Core
64-
T322PSM
65-
T431OLAP
66-
T611OLAP
6738
T631Core

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp