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

Commit8df2f37

Browse files
committed
Improve consistency of SQL code capitalization
1 parenta4d75c8 commit8df2f37

File tree

2 files changed

+8
-8
lines changed

2 files changed

+8
-8
lines changed

‎src/backend/catalog/system_views.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -47,7 +47,7 @@ CREATE VIEW pg_shadow AS
4747
ON (pg_authid.oid= setroleAND setdatabase=0)
4848
WHERE rolcanlogin;
4949

50-
REVOKE ALLon pg_shadowFROM public;
50+
REVOKE ALLON pg_shadowFROM public;
5151

5252
CREATEVIEWpg_groupAS
5353
SELECT
@@ -251,7 +251,7 @@ CREATE VIEW pg_stats WITH (security_barrier) AS
251251
AND has_column_privilege(c.oid,a.attnum,'select')
252252
AND (c.relrowsecurity= falseOR NOT row_security_active(c.oid));
253253

254-
REVOKE ALLon pg_statisticFROM public;
254+
REVOKE ALLON pg_statisticFROM public;
255255

256256
CREATEVIEWpg_stats_ext WITH (security_barrier)AS
257257
SELECTcn.nspnameAS schemaname,
@@ -360,7 +360,7 @@ CREATE VIEW pg_stats_ext_exprs WITH (security_barrier) AS
360360
) statON (stat.exprIS NOT NULL);
361361

362362
-- unprivileged users may read pg_statistic_ext but not pg_statistic_ext_data
363-
REVOKE ALLon pg_statistic_ext_dataFROM public;
363+
REVOKE ALLON pg_statistic_ext_dataFROM public;
364364

365365
CREATEVIEWpg_publication_tablesAS
366366
SELECT
@@ -596,13 +596,13 @@ GRANT SELECT, UPDATE ON pg_settings TO PUBLIC;
596596
CREATEVIEWpg_file_settingsAS
597597
SELECT*FROM pg_show_all_file_settings()AS A;
598598

599-
REVOKE ALLon pg_file_settingsFROM PUBLIC;
599+
REVOKE ALLON pg_file_settingsFROM PUBLIC;
600600
REVOKE EXECUTEON FUNCTION pg_show_all_file_settings()FROM PUBLIC;
601601

602602
CREATEVIEWpg_hba_file_rulesAS
603603
SELECT*FROM pg_hba_file_rules()AS A;
604604

605-
REVOKE ALLon pg_hba_file_rulesFROM PUBLIC;
605+
REVOKE ALLON pg_hba_file_rulesFROM PUBLIC;
606606
REVOKE EXECUTEON FUNCTION pg_hba_file_rules()FROM PUBLIC;
607607

608608
CREATEVIEWpg_timezone_abbrevsAS
@@ -614,7 +614,7 @@ CREATE VIEW pg_timezone_names AS
614614
CREATEVIEWpg_configAS
615615
SELECT*FROM pg_config();
616616

617-
REVOKE ALLon pg_configFROM PUBLIC;
617+
REVOKE ALLON pg_configFROM PUBLIC;
618618
REVOKE EXECUTEON FUNCTION pg_config()FROM PUBLIC;
619619

620620
CREATEVIEWpg_shmem_allocationsAS
@@ -1239,7 +1239,7 @@ CREATE VIEW pg_user_mappings AS
12391239
JOIN pg_foreign_server SON (U.umserver=S.oid)
12401240
LEFT JOIN pg_authid AON (A.oid=U.umuser);
12411241

1242-
REVOKE ALLon pg_user_mappingFROM public;
1242+
REVOKE ALLON pg_user_mappingFROM public;
12431243

12441244
CREATEVIEWpg_replication_origin_statusAS
12451245
SELECT*

‎src/bin/initdb/initdb.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1437,7 +1437,7 @@ setup_auth(FILE *cmdfd)
14371437
* The authid table shouldn't be readable except through views, to
14381438
* ensure passwords are not publicly visible.
14391439
*/
1440-
"REVOKE ALLon pg_authid FROM public;\n\n",
1440+
"REVOKE ALLON pg_authid FROM public;\n\n",
14411441
NULL
14421442
};
14431443

0 commit comments

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