NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitf73293a

committed

Fix some documentation about FKs and partitioned tables

This got forgotten in f56f8f which has added foreign key support forpartitioned tables. In passing, add a mention about caveats applying totables partitioned using inheritance regarding indexes and foreign keys.Author: Paul A JungwirthReviewed-by: Amit Langote, Michael PaquierDiscussion:https://postgr.es/m/CA+renyUuSmYgmZjKc_DfUNVZ0uttF91-FwhDVW3F7WEPj0jL5w@mail.gmail.com

1 parentd890fa8 commitf73293aCopy full SHA for f73293a

File tree

1 file changed

-8

lines changed

doc/src/sgml
- ddl.sgml

1 file changed

-8

lines changed

`‎doc/src/sgml/ddl.sgml`

Lines changed: 8 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -3964,14 +3964,6 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02`
`3964`	`3964`	`</para>`
`3965`	`3965`	`</listitem>`
`3966`	`3966`
`3967`		`- <listitem>`
`3968`		`- <para>`
`3969`		`- While primary keys are supported on partitioned tables, foreign`
`3970`		`- keys referencing partitioned tables are not supported. (Foreign key`
`3971`		`- references from a partitioned table to some other table are supported.)`
`3972`		`- </para>`
`3973`		`- </listitem>`
`3974`		`-`
`3975`	`3967`	`<listitem>`
`3976`	`3968`	`<para>`
`3977`	`3969`	`<literal>BEFORE ROW</literal> triggers, if necessary, must be defined`
`@@ -4354,6 +4346,14 @@ ALTER TABLE measurement_y2008m02 INHERIT measurement;`
`4354`	`4346`	`</para>`
`4355`	`4347`	`</listitem>`
`4356`	`4348`
	`4349`	`+ <listitem>`
	`4350`	`+ <para>`
	`4351`	`+ Indexes and foreign key constraints apply to single tables and not`
	`4352`	`+ to their inheritance children, hence they have some`
	`4353`	`+ <link linkend="ddl-inherit-caveats">caveats</link> to be aware of.`
	`4354`	`+ </para>`
	`4355`	`+ </listitem>`
	`4356`	`+`
`4357`	`4357`	`<listitem>`
`4358`	`4358`	`<para>`
`4359`	`4359`	`The schemes shown here assume that the values of a row's key column(s)`

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!

Commitf73293a

File tree

1 file changed

1 file changed

`‎doc/src/sgml/ddl.sgml`

0 commit comments