Horton

Improve two error messages related to foreign keys on partitioned tables

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 9c2a970d1fa4d30dc41d30d0b2ad557f40510549
Author: Michael Paquier <michael@paquier.xyz>
Date: 2018-10-08T08:56:13Z
Releases: 12.0 
Improve two error messages related to foreign keys on partitioned tables

Error messages for creating a foreign key on a partitioned table using
ONLY or NOT VALID were wrong in mentioning the objects they worked on.
This commit adds on the way some regression tests missing for those
cases.

Author: Laurenz Albe
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/c11c05810a9ed65e9b2c817a9ef442275a32fe80.camel@cybertec.at

Files

PathChange+/−
src/backend/commands/tablecmds.c modified +4 −2
src/test/regress/expected/foreign_key.out modified +11 −0
src/test/regress/sql/foreign_key.sql modified +9 −0

Discussion