NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit6bdf4b9

committed

Fix REASSIGN OWNED for text search objects

Trying to reassign objects owned by a user that had text searchdictionaries or configurations used to fail with:ERROR: unexpected classid 3600orERROR: unexpected classid 3602Fix by adding cases for those object types in a switch in pg_shdepend.c.Both REASSIGN OWNED and text search objects go back all the way to 8.1,so backpatch to all supported branches. In 9.3 the alter-owner code wasmade generic, so the required change in recent branches is prettysimple; however, for 9.2 and older ones we need some additionalreshuffling to enable specifying objects by OID rather than name.Text search templates and parsers are not owned objects, so there's nochange required for them.Per bug #9749 reported by Michal Novotný

1 parentc9e1ad7 commit6bdf4b9Copy full SHA for 6bdf4b9

File tree

1 file changed

-0

lines changed

src/backend/catalog
- pg_shdepend.c

1 file changed

-0

lines changed

`‎src/backend/catalog/pg_shdepend.c`

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -40,6 +40,8 @@`
`40`	`40`	`#include"catalog/pg_proc.h"`
`41`	`41`	`#include"catalog/pg_shdepend.h"`
`42`	`42`	`#include"catalog/pg_tablespace.h"`
	`43`	`+#include"catalog/pg_ts_config.h"`
	`44`	`+#include"catalog/pg_ts_dict.h"`
`43`	`45`	`#include"catalog/pg_type.h"`
`44`	`46`	`#include"commands/alter.h"`
`45`	`47`	`#include"commands/dbcommands.h"`
`@@ -1394,6 +1396,8 @@ shdepReassignOwned(List *roleids, Oid newrole)`
`1394`	`1396`	`caseExtensionRelationId:`
`1395`	`1397`	`caseTableSpaceRelationId:`
`1396`	`1398`	`caseDatabaseRelationId:`
	`1399`	`+caseTSConfigRelationId:`
	`1400`	`+caseTSDictionaryRelationId:`
`1397`	`1401`	`{`
`1398`	`1402`	`OidclassId=sdepForm->classid;`
`1399`	`1403`	`Relationcatalog;`

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!

Commit6bdf4b9

File tree

1 file changed

1 file changed

`‎src/backend/catalog/pg_shdepend.c`

0 commit comments