NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitdce90c7

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 commitdce90c7Copy full SHA for dce90c7

File tree

1 file changed

-1

lines changed

src/backend/catalog
- information_schema.sql

1 file changed

-1

lines changed

`‎src/backend/catalog/information_schema.sql`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1853,7 +1853,7 @@ CREATE VIEW table_privileges AS`
`1853`	`1853`	`)AS grantee (oid, rolname)`
`1854`	`1854`
`1855`	`1855`	`WHEREc.relnamespace=nc.oid`
`1856`		`-ANDc.relkindIN ('r','v')`
	`1856`	`+ANDc.relkindIN ('r','v','f')`
`1857`	`1857`	`ANDc.grantee=grantee.oid`
`1858`	`1858`	`ANDc.grantor=u_grantor.oid`
`1859`	`1859`	`ANDc.prtypeIN ('INSERT','SELECT','UPDATE','DELETE','TRUNCATE','REFERENCES','TRIGGER')`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitdce90c7

File tree

1 file changed

1 file changed

`‎src/backend/catalog/information_schema.sql`

0 commit comments