On Wednesday, November 6, 2024, kasaharatt <
kasaharatt@oss.nttdata.com> wrote:.
I noticed that it seems to me a mistake in the sample code in the document.
https://www.postgresql.org/docs/devel/ddl-constraints.html#DDL-CONSTRAINTS-FK
I think it is a typo for user_id instead of author_id.
It’s hard to argue a typo when three different places need to be changed, and the example is fully functional as-is.
The example writer intentionally chose to make author_id the FK of the PK user_id column in order to reduce ambiguity as to which column is on the FK table and which is on the PK table. And to emphasize that the columns need not be named the same in any case.
David J.
