Commit220857a

committed

Mention limitation of unique in partitioned tables

1 parenta5c2f3a commit220857aCopy full SHA for 220857a

File tree

-0

lines changed

-0

lines changed

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -4003,6 +4003,15 @@ ALTER INDEX measurement_city_id_logdate_key`
`4003`	`4003`	`</para>`
`4004`	`4004`	`</listitem>`
`4005`	`4005`
	`4006`	`+ <listitem>`
	`4007`	`+ <para>`
	`4008`	`+ Unique constraints on partitioned tables must include all the`
	`4009`	`+ partition key columns. This limitation exists because`
	`4010`	`+ <productname>PostgreSQL</productname> can only enforce`
	`4011`	`+ uniqueness in each partition individually.`
	`4012`	`+ </para>`
	`4013`	`+ </listitem>`
	`4014`	`+`
`4006`	`4015`	`<listitem>`
`4007`	`4016`	`<para>`
`4008`	`4017`	`<literal>BEFORE ROW</literal> triggers, if necessary, must be defined`

Comments

(0)