Commit9331629

committed

psql: have \d show FKs on partitioned tables

Commit3de241d missed to update psql to display foreign keys onpartitioned tables. Add that.Reported-by: Amit LangoteAuthor: Amit LangoteReviewed-by: Álvaro HerreraDiscussion:https://postgr.es/m/a66879e5-636f-d4dd-b4a4-92bdca5a828f@lab.ntt.co.jp

1 parent60e2d9a commit9331629Copy full SHA for 9331629

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -2311,8 +2311,13 @@ describeOneTableDetails(const char *schemaname,`
`2311`	`2311`	`PQclear(result);`
`2312`	`2312`	`}`
`2313`	`2313`
`2314`		`-/* print foreign-key constraints (there are none if no triggers) */`
`2315`		`-if (tableinfo.hastriggers)`
	`2314`	`+/*`
	`2315`	`+ * Print foreign-key constraints (there are none if no triggers,`
	`2316`	`+ * except if the table is partitioned, in which case the triggers`
	`2317`	`+ * appear in the partitions)`
	`2318`	`+ */`
	`2319`	`+if (tableinfo.hastriggers\|\|`
	`2320`	`+tableinfo.relkind==RELKIND_PARTITIONED_TABLE)`
`2316`	`2321`	`{`
`2317`	`2322`	`printfPQExpBuffer(&buf,`
`2318`	`2323`	`"SELECT conname,\n"`

Comments

(0)