NotificationsYou must be signed in to change notification settings
Fork28
Star153

Commitfc8cf3d

committed

Fix privileges on pg_statistic_ext.tableoid

The GRANT in system_views allowed SELECT privileges on various columns inthe pg_statistic_ext catalog, but tableoid was not included in the list.That made pg_dump fail because it's accessing this column when buildingthe list of extended statistics to dump.Discussion:https://postgr.es/m/8833.1560647898%40sss.pgh.pa.us

1 parent7f44efa commitfc8cf3dCopy full SHA for fc8cf3d

File tree

1 file changed

-1

lines changed

src/backend/catalog
- system_views.sql

1 file changed

-1

lines changed

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

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -291,7 +291,7 @@ CREATE VIEW pg_stats_ext WITH (security_barrier) AS`
`291`	`291`	`AND (c.relrowsecurity= falseOR NOT row_security_active(c.oid));`
`292`	`292`
`293`	`293`	`REVOKE ALLon pg_statistic_extFROM public;`
`294`		`-GRANTSELECT (oid, stxrelid, stxname, stxnamespace, stxowner, stxkeys, stxkind)`
	`294`	`+GRANTSELECT (tableoid,oid, stxrelid, stxname, stxnamespace, stxowner, stxkeys, stxkind)`
`295`	`295`	`ON pg_statistic_ext TO public;`
`296`	`296`
`297`	`297`	`CREATEVIEWpg_publication_tablesAS`

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!

Commitfc8cf3d

File tree

1 file changed

1 file changed

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

0 commit comments