NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commitf56f8f8

committed

Support foreign keys that reference partitioned tables

Previously, while primary keys could be made on partitioned tables, itwas not possible to define foreign keys that reference those primarykeys. Now it is possible to do that.Author: Álvaro HerreraReviewed-by: Amit Langote, Jesper PedersenDiscussion:https://postgr.es/m/20181102234158.735b3fevta63msbj@alvherre.pgsql

1 parent9155580 commitf56f8f8Copy full SHA for f56f8f8

File tree

15 files changed

+2039

-431

lines changed

doc/src/sgml/ref
- create_table.sgml
src
- backend
  - commands
    - tablecmds.c
  - utils/adt
    - ri_triggers.c
    - ruleutils.c
- bin/psql
  - describe.c
- include
  - commands
    - tablecmds.h
    - trigger.h
  - utils
    - ruleutils.h
- test
  - isolation
    - expected
      - fk-partitioned-1.out
      - fk-partitioned-2.out
    - isolation_schedule
    - specs
      - fk-partitioned-1.spec
      - fk-partitioned-2.spec
  - regress
    - expected
      - foreign_key.out
    - sql
      - foreign_key.sql

15 files changed

+2039

-431

lines changed

`‎doc/src/sgml/ref/create_table.sgml`

Lines changed: 1 addition & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -379,9 +379,6 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`379`	`379`	`<para>`
`380`	`380`	`Partitioned tables do not support <literal>EXCLUDE</literal> constraints;`
`381`	`381`	`however, you can define these constraints on individual partitions.`
`382`		`- Also, while it's possible to define <literal>PRIMARY KEY</literal>`
`383`		`- constraints on partitioned tables, creating foreign keys that`
`384`		`- reference a partitioned table is not yet supported.`
`385`	`382`	`</para>`
`386`	`383`
`387`	`384`	`<para>`
`@@ -1028,9 +1025,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`1028`	`1025`	`addition of a foreign key constraint requires a`
`1029`	`1026`	`<literal>SHARE ROW EXCLUSIVE</literal> lock on the referenced table.`
`1030`	`1027`	`Note that foreign key constraints cannot be defined between temporary`
`1031`		`- tables and permanent tables. Also note that while it is possible to`
`1032`		`- define a foreign key on a partitioned table, it is not possible to`
`1033`		`- declare a foreign key that references a partitioned table.`
	`1028`	`+ tables and permanent tables.`
`1034`	`1029`	`</para>`
`1035`	`1030`
`1036`	`1031`	`<para>`

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!

Commitf56f8f8

File tree

15 files changed

15 files changed

`‎doc/src/sgml/ref/create_table.sgml`

0 commit comments