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

Commiteb3a137

Browse files
committed
Update information_schema for SQL:2016
This is mainly a light renumbering to match the sections in thestandard.
1 parentc29ba98 commiteb3a137

File tree

1 file changed

+49
-42
lines changed

1 file changed

+49
-42
lines changed

‎src/backend/catalog/information_schema.sql

Lines changed: 49 additions & 42 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
/*
22
* SQL Information Schema
3-
* as defined in ISO/IEC 9075-11:2011
3+
* as defined in ISO/IEC 9075-11:2016
44
*
55
* Copyright (c) 2003-2019, PostgreSQL Global Development Group
66
*
@@ -1206,14 +1206,22 @@ GRANT SELECT ON parameters TO PUBLIC;
12061206

12071207
/*
12081208
* 5.39
1209-
*REFERENCED_TYPES view
1209+
*PRIVATE_PARAMETERS view
12101210
*/
12111211

12121212
-- feature not supported
12131213

12141214

12151215
/*
12161216
* 5.40
1217+
* REFERENCED_TYPES view
1218+
*/
1219+
1220+
-- feature not supported
1221+
1222+
1223+
/*
1224+
* 5.41
12171225
* REFERENTIAL_CONSTRAINTS view
12181226
*/
12191227

@@ -1275,7 +1283,7 @@ GRANT SELECT ON referential_constraints TO PUBLIC;
12751283

12761284

12771285
/*
1278-
* 5.41
1286+
* 5.42
12791287
* ROLE_COLUMN_GRANTS view
12801288
*/
12811289

@@ -1295,45 +1303,45 @@ CREATE VIEW role_column_grants AS
12951303
GRANTSELECTON role_column_grants TO PUBLIC;
12961304

12971305

1298-
-- 5.42 ROLE_ROUTINE_GRANTS view is based on 5.49 ROUTINE_PRIVILEGES and is defined there instead.
1306+
-- 5.43 ROLE_ROUTINE_GRANTS view is based on 5.50 ROUTINE_PRIVILEGES and is defined there instead.
12991307

13001308

1301-
-- 5.43 ROLE_TABLE_GRANTS view is based on 5.62 TABLE_PRIVILEGES and is defined there instead.
1309+
-- 5.44 ROLE_TABLE_GRANTS view is based on 5.63 TABLE_PRIVILEGES and is defined there instead.
13021310

13031311

13041312
/*
1305-
* 5.44
1313+
* 5.45
13061314
* ROLE_TABLE_METHOD_GRANTS view
13071315
*/
13081316

13091317
-- feature not supported
13101318

13111319

13121320

1313-
-- 5.45 ROLE_USAGE_GRANTS view is based on 5.74 USAGE_PRIVILEGES and is defined there instead.
1321+
-- 5.46 ROLE_USAGE_GRANTS view is based on 5.75 USAGE_PRIVILEGES and is defined there instead.
13141322

13151323

1316-
-- 5.46 ROLE_UDT_GRANTS view is based on 5.73 UDT_PRIVILEGES and is defined there instead.
1324+
-- 5.47 ROLE_UDT_GRANTS view is based on 5.74 UDT_PRIVILEGES and is defined there instead.
13171325

13181326

13191327
/*
1320-
* 5.47
1328+
* 5.48
13211329
* ROUTINE_COLUMN_USAGE view
13221330
*/
13231331

13241332
-- not tracked by PostgreSQL
13251333

13261334

13271335
/*
1328-
* 5.48
1336+
* 5.49
13291337
* ROUTINE_PERIOD_USAGE view
13301338
*/
13311339

13321340
-- feature not supported
13331341

13341342

13351343
/*
1336-
* 5.49
1344+
* 5.50
13371345
* ROUTINE_PRIVILEGES view
13381346
*/
13391347

@@ -1400,31 +1408,31 @@ GRANT SELECT ON role_routine_grants TO PUBLIC;
14001408

14011409

14021410
/*
1403-
* 5.50
1411+
* 5.51
14041412
* ROUTINE_ROUTINE_USAGE view
14051413
*/
14061414

14071415
-- not tracked by PostgreSQL
14081416

14091417

14101418
/*
1411-
* 5.51
1419+
* 5.52
14121420
* ROUTINE_SEQUENCE_USAGE view
14131421
*/
14141422

14151423
-- not tracked by PostgreSQL
14161424

14171425

14181426
/*
1419-
* 5.52
1427+
* 5.53
14201428
* ROUTINE_TABLE_USAGE view
14211429
*/
14221430

14231431
-- not tracked by PostgreSQL
14241432

14251433

14261434
/*
1427-
* 5.53
1435+
* 5.54
14281436
* ROUTINES view
14291437
*/
14301438

@@ -1542,7 +1550,7 @@ GRANT SELECT ON routines TO PUBLIC;
15421550

15431551

15441552
/*
1545-
* 5.54
1553+
* 5.55
15461554
* SCHEMATA view
15471555
*/
15481556

@@ -1563,7 +1571,7 @@ GRANT SELECT ON schemata TO PUBLIC;
15631571

15641572

15651573
/*
1566-
* 5.55
1574+
* 5.56
15671575
* SEQUENCES view
15681576
*/
15691577

@@ -1593,7 +1601,7 @@ GRANT SELECT ON sequences TO PUBLIC;
15931601

15941602

15951603
/*
1596-
* 5.56
1604+
* 5.57
15971605
* SQL_FEATURES table
15981606
*/
15991607

@@ -1613,7 +1621,7 @@ GRANT SELECT ON sql_features TO PUBLIC;
16131621

16141622

16151623
/*
1616-
* 5.57
1624+
* 5.58
16171625
* SQL_IMPLEMENTATION_INFO table
16181626
*/
16191627

@@ -1695,7 +1703,7 @@ GRANT SELECT ON sql_packages TO PUBLIC;
16951703

16961704

16971705
/*
1698-
* 5.58
1706+
* 5.59
16991707
* SQL_PARTS table
17001708
*/
17011709

@@ -1719,7 +1727,7 @@ INSERT INTO sql_parts VALUES ('14', 'XML-Related Specifications (SQL/XML)', 'YES
17191727

17201728

17211729
/*
1722-
* 5.59
1730+
* 5.60
17231731
* SQL_SIZING table
17241732
*/
17251733

@@ -1785,7 +1793,7 @@ GRANT SELECT ON sql_sizing_profiles TO PUBLIC;
17851793

17861794

17871795
/*
1788-
* 5.60
1796+
* 5.61
17891797
* TABLE_CONSTRAINTS view
17901798
*/
17911799

@@ -1858,15 +1866,15 @@ GRANT SELECT ON table_constraints TO PUBLIC;
18581866

18591867

18601868
/*
1861-
* 5.61
1869+
* 5.62
18621870
* TABLE_METHOD_PRIVILEGES view
18631871
*/
18641872

18651873
-- feature not supported
18661874

18671875

18681876
/*
1869-
* 5.62
1877+
* 5.63
18701878
* TABLE_PRIVILEGES view
18711879
*/
18721880

@@ -1976,7 +1984,7 @@ GRANT SELECT ON tables TO PUBLIC;
19761984

19771985

19781986
/*
1979-
* 5.64
1987+
* 5.65
19801988
* TRANSFORMS view
19811989
*/
19821990

@@ -2016,15 +2024,15 @@ CREATE VIEW transforms AS
20162024

20172025

20182026
/*
2019-
* 5.65
2027+
* 5.66
20202028
* TRANSLATIONS view
20212029
*/
20222030

20232031
-- feature not supported
20242032

20252033

20262034
/*
2027-
* 5.66
2035+
* 5.67
20282036
* TRIGGERED_UPDATE_COLUMNS view
20292037
*/
20302038

@@ -2056,47 +2064,47 @@ GRANT SELECT ON triggered_update_columns TO PUBLIC;
20562064

20572065

20582066
/*
2059-
* 5.67
2067+
* 5.68
20602068
* TRIGGER_COLUMN_USAGE view
20612069
*/
20622070

20632071
-- not tracked by PostgreSQL
20642072

20652073

20662074
/*
2067-
* 5.68
2075+
* 5.69
20682076
* TRIGGER_PERIOD_USAGE view
20692077
*/
20702078

20712079
-- feature not supported
20722080

20732081

20742082
/*
2075-
* 5.69
2083+
* 5.70
20762084
* TRIGGER_ROUTINE_USAGE view
20772085
*/
20782086

20792087
-- not tracked by PostgreSQL
20802088

20812089

20822090
/*
2083-
* 5.70
2091+
* 5.71
20842092
* TRIGGER_SEQUENCE_USAGE view
20852093
*/
20862094

20872095
-- not tracked by PostgreSQL
20882096

20892097

20902098
/*
2091-
* 5.71
2099+
* 5.72
20922100
* TRIGGER_TABLE_USAGE view
20932101
*/
20942102

20952103
-- not tracked by PostgreSQL
20962104

20972105

20982106
/*
2099-
* 5.72
2107+
* 5.73
21002108
* TRIGGERS view
21012109
*/
21022110

@@ -2158,7 +2166,7 @@ GRANT SELECT ON triggers TO PUBLIC;
21582166

21592167

21602168
/*
2161-
* 5.73
2169+
* 5.74
21622170
* UDT_PRIVILEGES view
21632171
*/
21642172

@@ -2220,7 +2228,7 @@ GRANT SELECT ON role_udt_grants TO PUBLIC;
22202228

22212229

22222230
/*
2223-
* 5.74
2231+
* 5.75
22242232
* USAGE_PRIVILEGES view
22252233
*/
22262234

@@ -2412,7 +2420,7 @@ GRANT SELECT ON role_usage_grants TO PUBLIC;
24122420

24132421

24142422
/*
2415-
* 5.75
2423+
* 5.76
24162424
* USER_DEFINED_TYPES view
24172425
*/
24182426

@@ -2459,7 +2467,7 @@ GRANT SELECT ON user_defined_types TO PUBLIC;
24592467

24602468

24612469
/*
2462-
* 5.76
2470+
* 5.77
24632471
* VIEW_COLUMN_USAGE
24642472
*/
24652473

@@ -2498,15 +2506,15 @@ GRANT SELECT ON view_column_usage TO PUBLIC;
24982506

24992507

25002508
/*
2501-
* 5.77
2509+
* 5.78
25022510
* VIEW_PERIOD_USAGE
25032511
*/
25042512

25052513
-- feature not supported
25062514

25072515

25082516
/*
2509-
* 5.78
2517+
* 5.79
25102518
* VIEW_ROUTINE_USAGE
25112519
*/
25122520

@@ -2539,7 +2547,7 @@ GRANT SELECT ON view_routine_usage TO PUBLIC;
25392547

25402548

25412549
/*
2542-
* 5.79
2550+
* 5.80
25432551
* VIEW_TABLE_USAGE
25442552
*/
25452553

@@ -2574,7 +2582,7 @@ GRANT SELECT ON view_table_usage TO PUBLIC;
25742582

25752583

25762584
/*
2577-
* 5.80
2585+
* 5.81
25782586
* VIEWS view
25792587
*/
25802588

@@ -2767,7 +2775,6 @@ GRANT SELECT ON element_types TO PUBLIC;
27672775

27682776

27692777
-- SQL/MED views; these use section numbers from part 9 of the standard.
2770-
-- (still SQL:2008; there is no SQL:2011 SQL/MED)
27712778

27722779
/* Base view for foreign table columns*/
27732780
CREATEVIEW_pg_foreign_table_columnsAS

0 commit comments

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