Example. Foreign Keys Constraints. Wrong Columns
| От | PG Doc comments form |
|---|---|
| Тема | Example. Foreign Keys Constraints. Wrong Columns |
| Дата | |
| Msg-id | 177616491576.403057.11334419722719232554@wrigleys.postgresql.org обсуждение |
| Ответы |
Re: Example. Foreign Keys Constraints. Wrong Columns
|
| Список | pgsql-docs |
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/18/ddl-constraints.html Description: https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-FK In the last example of this section it seems the `users` table is referenced wrong. ```sql CREATE TABLE users ( tenant_id integer REFERENCES tenants ON DELETE CASCADE, user_id integer NOT NULL, PRIMARY KEY (tenant_id, user_id) ); CREATE TABLE posts ( tenant_id integer REFERENCES tenants ON DELETE CASCADE, post_id integer NOT NULL, author_id integer, PRIMARY KEY (tenant_id, post_id), FOREIGN KEY (tenant_id, author_id) REFERENCES users ON DELETE SET NULL (author_id) ); ``` In this example `FOREIGN KEY (tenant_id, author_id) REFERENCES users ON DELETE SET NULL (author_id)` implies that `users` table columns are named `(tenant_id, author_id)` but in fact `users` table does not have a `author_id` column. That line should be probably like this because `users` tables has a `user_id` column instead of `author_id` ```sql CREATE TABLE posts ( # ... FOREIGN KEY (tenant_id, author_id) REFERENCES users (tenant_id, user_id) ON DELETE SET NULL (author_id) ); ```
В списке pgsql-docs по дате отправления: