Commit5918b82

committed

Mention limitation of unique in partitioned tables

1 parent2ede93d commit5918b82Copy full SHA for 5918b82

File tree

-0

lines changed

-0

lines changed

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3386,6 +3386,15 @@ ALTER INDEX measurement_city_id_logdate_key`
`3386`	`3386`	`</para>`
`3387`	`3387`	`</listitem>`
`3388`	`3388`
	`3389`	`+ <listitem>`
	`3390`	`+ <para>`
	`3391`	`+ Unique constraints on partitioned tables must include all the`
	`3392`	`+ partition key columns. This limitation exists because`
	`3393`	`+ <productname>PostgreSQL</productname> can only enforce`
	`3394`	`+ uniqueness in each partition individually.`
	`3395`	`+ </para>`
	`3396`	`+ </listitem>`
	`3397`	`+`
`3389`	`3398`	`<listitem>`
`3390`	`3399`	`<para>`
`3391`	`3400`	`While primary keys are supported on partitioned tables, foreign`

Comments

(0)