Thread: pgsql: Doc: mention foreign keys can reference unique indexes
Doc: mention foreign keys can reference unique indexes We seem to have only documented a foreign key can reference the columns of a primary key or unique constraint. Here we adjust the documentation to mention columns in a non-partial unique index can be mentioned too. The header comment for transformFkeyCheckAttrs() also didn't mention unique indexes, so fix that too. In passing make that header comment reflect reality in the various other aspects where it deviated from it. Bug: 18295 Reported-by: Gilles PARC Author: Laurenz Albe, David Rowley Discussion: https://www.postgresql.org/message-id/18295-0ed0fac5c9f7b17b%40postgresql.org Backpatch-through: 12 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/6fc8a7b2b03bfcb26e2e7440251b6f17e01210c8 Modified Files -------------- doc/src/sgml/ddl.sgml | 20 ++++++++++---------- doc/src/sgml/ref/create_table.sgml | 19 +++++++++++++------ src/backend/commands/tablecmds.c | 14 +++++++++----- 3 files changed, 32 insertions(+), 21 deletions(-)