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

Commitdce90c7

Browse files
committed
Include foreign tables in information_schema.table_privileges
This appears to have been an omission in the original commit0d692a0. All related information_schema views already includeforeign tables.Reported-by: Nicolas Thauvin <nicolas.thauvin@dalibo.com>
1 parent62c9eaf commitdce90c7

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

‎src/backend/catalog/information_schema.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1853,7 +1853,7 @@ CREATE VIEW table_privileges AS
18531853
)AS grantee (oid, rolname)
18541854

18551855
WHEREc.relnamespace=nc.oid
1856-
ANDc.relkindIN ('r','v')
1856+
ANDc.relkindIN ('r','v','f')
18571857
ANDc.grantee=grantee.oid
18581858
ANDc.grantor=u_grantor.oid
18591859
ANDc.prtypeIN ('INSERT','SELECT','UPDATE','DELETE','TRUNCATE','REFERENCES','TRIGGER')

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp