NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commite8cb8fd

committed

Fix objectaddress.c code for publication relations.

getObjectDescription and getObjectIdentity failed to schema-qualifythe name of the published table, which is bad in getObjectDescription andunforgivable in getObjectIdentity. Actually, getObjectIdentity failed toemit the table's name at all unless "objname" output is requested, whichaccidentally works for some (all?) extant callers but is clearly not theintended API. Somebody had also not gotten the memo that the output ofgetObjectIdentity is not to be translated.To fix getObjectDescription, I made it call getRelationDescription, whichrequired refactoring the translatable string for the case, but is morefuture-proof in case we ever publish relations that aren't plain tables.While at it, I made the English output look like "publication of table Xin publication Y"; the added "of" seems to me to make it read much better.Back-patch to v10 where publications were introduced.Discussion:https://postgr.es/m/20180522.182020.114074746.horiguchi.kyotaro@lab.ntt.co.jp

1 parenteb1aa1b commite8cb8fdCopy full SHA for e8cb8fd

File tree

2 files changed

+14

-9

lines changed

src
- backend/catalog
  - objectaddress.c
- test/regress/expected
  - object_address.out

2 files changed

+14

-9

lines changed

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

Lines changed: 13 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -3446,6 +3446,7 @@ getObjectDescription(const ObjectAddress *object)`
`3446`	`3446`	`HeapTupletup;`
`3447`	`3447`	`char*pubname;`
`3448`	`3448`	`Form_pg_publication_relprform;`
	`3449`	`+StringInfoDatarel;`
`3449`	`3450`
`3450`	`3451`	`tup=SearchSysCache1(PUBLICATIONREL,`
`3451`	`3452`	`ObjectIdGetDatum(object->objectId));`
`@@ -3456,8 +3457,13 @@ getObjectDescription(const ObjectAddress *object)`
`3456`	`3457`	`prform= (Form_pg_publication_rel)GETSTRUCT(tup);`
`3457`	`3458`	`pubname=get_publication_name(prform->prpubid);`
`3458`	`3459`
`3459`		`-appendStringInfo(&buffer,_("publication table %s in publication %s"),`
`3460`		`-get_rel_name(prform->prrelid),pubname);`
	`3460`	`+initStringInfo(&rel);`
	`3461`	`+getRelationDescription(&rel,prform->prrelid);`
	`3462`	`+`
	`3463`	`+/* translator: first %s is, e.g., "table %s" */`
	`3464`	`+appendStringInfo(&buffer,_("publication of %s in publication %s"),`
	`3465`	`+rel.data,pubname);`
	`3466`	`+pfree(rel.data);`
`3461`	`3467`	`ReleaseSysCache(tup);`
`3462`	`3468`	`break;`
`3463`	`3469`	`}`
`@@ -3516,6 +3522,8 @@ getObjectDescriptionOids(Oid classid, Oid objid)`
`3516`	`3522`
`3517`	`3523`	`/*`
`3518`	`3524`	`* subroutine for getObjectDescription: describe a relation`
	`3525`	`+ *`
	`3526`	`+ * The result is appended to "buffer".`
`3519`	`3527`	`*/`
`3520`	`3528`	`staticvoid`
`3521`	`3529`	`getRelationDescription(StringInfobuffer,Oidrelid)`
`@@ -4982,14 +4990,11 @@ getObjectIdentityParts(const ObjectAddress *object,`
`4982`	`4990`	`prform= (Form_pg_publication_rel)GETSTRUCT(tup);`
`4983`	`4991`	`pubname=get_publication_name(prform->prpubid);`
`4984`	`4992`
`4985`		`-appendStringInfo(&buffer,_("%s in publication %s"),`
`4986`		`-get_rel_name(prform->prrelid),pubname);`
	`4993`	`+getRelationIdentity(&buffer,prform->prrelid,objname);`
	`4994`	`+appendStringInfo(&buffer," in publication %s",pubname);`
`4987`	`4995`
`4988`		`-if (objname)`
`4989`		`-{`
`4990`		`-getRelationIdentity(&buffer,prform->prrelid,objname);`
	`4996`	`+if (objargs)`
`4991`	`4997`	`*objargs=list_make1(pubname);`
`4992`		`-}`
`4993`	`4998`
`4994`	`4999`	`ReleaseSysCache(tup);`
`4995`	`5000`	`break;`

`‎src/test/regress/expected/object_address.out`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -468,7 +468,7 @@ SELECT (pg_identify_object(addr1.classid, addr1.objid, addr1.objsubid)).*,`
`468`	`468`	`text search template \| addr_nsp \| addr_ts_temp \| addr_nsp.addr_ts_temp \| t`
`469`	`469`	`subscription \| \| addr_sub \| addr_sub \| t`
`470`	`470`	`publication \| \| addr_pub \| addr_pub \| t`
`471`		`- publication relation \| \| \| gentable in publication addr_pub \| t`
	`471`	`+ publication relation \| \| \|addr_nsp.gentable in publication addr_pub \| t`
`472`	`472`	`(46 rows)`
`473`	`473`
`474`	`474`	`---`

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!

Commite8cb8fd

File tree

2 files changed

2 files changed

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

`‎src/test/regress/expected/object_address.out`

0 commit comments