diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-09-30 18:25:23 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-09-30 18:25:23 -0300 |
| commit | 9fc21227128980f88b6eb6d5306625af0428ef45 (patch) | |
| tree | 8ff388ba0393bb0c52a8602881075e6c71048872 /src/backend/commands/indexcmds.c | |
| parent | 489c9c3407cbfd473c2f8d7863ffaaf6d2e8fcf8 (diff) | |
| download | postgresql-9fc21227128980f88b6eb6d5306625af0428ef45.tar.gz postgresql-9fc21227128980f88b6eb6d5306625af0428ef45.zip | |
Reword partitioning error message
The error message about columns in the primary key not including all of
the partition key was unclear; reword it.
Backpatch all the way to pg11, where it appeared.
Reported-by: Nagaraj Raj <nagaraj.sf@yahoo.com>
Discussion: https://postgr.es/m/64062533.78364.1601415362244@mail.yahoo.com
Diffstat (limited to 'src/backend/commands/indexcmds.c')
| -rw-r--r-- | src/backend/commands/indexcmds.c | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/src/backend/commands/indexcmds.c b/src/backend/commands/indexcmds.c index 59e04b47dfb..75552c64ed2 100644 --- a/src/backend/commands/indexcmds.c +++ b/src/backend/commands/indexcmds.c @@ -1002,8 +1002,7 @@ DefineIndex(Oid relationId, key->partattrs[i] - 1); ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), - errmsg("insufficient columns in %s constraint definition", - constraint_type), + errmsg("unique constraint on partitioned table must include all partitioning columns"), errdetail("%s constraint on table \"%s\" lacks column \"%s\" which is part of the partition key.", constraint_type, RelationGetRelationName(rel), NameStr(att->attname)))); |