pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Doc: mention foreign keys can reference unique indexes 6+ messages / 1 participants [nested] [flat]
* pgsql: Doc: mention foreign keys can reference unique indexes @ 2024-01-29 21:15 David Rowley <drowley@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: David Rowley @ 2024-01-29 21:15 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/c85977d8fef7b18f69e0be72923ddb8dcc8165b5 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Doc: mention foreign keys can reference unique indexes @ 2024-01-29 21:16 David Rowley <drowley@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: David Rowley @ 2024-01-29 21:16 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1c8336e3e2f35e3968f73afc3a78ff34aaa523e2 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Doc: mention foreign keys can reference unique indexes @ 2024-01-29 21:16 David Rowley <drowley@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: David Rowley @ 2024-01-29 21:16 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Doc: mention foreign keys can reference unique indexes @ 2024-01-29 21:16 David Rowley <drowley@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: David Rowley @ 2024-01-29 21:16 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/973e14028e85364d81c78270ff00440e21e281fd 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, 34 insertions(+), 19 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Doc: mention foreign keys can reference unique indexes @ 2024-01-29 21:17 David Rowley <drowley@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: David Rowley @ 2024-01-29 21:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/eda1d0dfe681e9b87c06157e2b0b6864344944f1 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, 34 insertions(+), 19 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Doc: mention foreign keys can reference unique indexes @ 2024-01-29 21:17 David Rowley <drowley@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: David Rowley @ 2024-01-29 21:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/dff1756c392ec7e3ac9b0b4bb2112a594765902a 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, 34 insertions(+), 19 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-01-29 21:17 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-01-29 21:15 pgsql: Doc: mention foreign keys can reference unique indexes David Rowley <drowley@postgresql.org> 2024-01-29 21:16 pgsql: Doc: mention foreign keys can reference unique indexes David Rowley <drowley@postgresql.org> 2024-01-29 21:16 pgsql: Doc: mention foreign keys can reference unique indexes David Rowley <drowley@postgresql.org> 2024-01-29 21:16 pgsql: Doc: mention foreign keys can reference unique indexes David Rowley <drowley@postgresql.org> 2024-01-29 21:17 pgsql: Doc: mention foreign keys can reference unique indexes David Rowley <drowley@postgresql.org> 2024-01-29 21:17 pgsql: Doc: mention foreign keys can reference unique indexes David Rowley <drowley@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox