Doc: typo in ddl.sgml
От | kasaharatt |
---|---|
Тема | Doc: typo in ddl.sgml |
Дата | |
Msg-id | 84c1305f471bb5f73b4b407b4c2de64c@oss.nttdata.com обсуждение исходный текст |
Ответы |
Re: Doc: typo in ddl.sgml
|
Список | pgsql-hackers |
Hi. 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. See bellow. Best reghards, diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 898b6dd..c0de169 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1269,9 +1269,9 @@ CREATE TABLE users ( CREATE TABLE posts ( tenant_id integer REFERENCES tenants ON DELETE CASCADE, post_id integer NOT NULL, - author_id integer, + user_id integer, PRIMARY KEY (tenant_id, post_id), - FOREIGN KEY (tenant_id, author_id) REFERENCES users ON DELETE SET NULL <emphasis>(author_id)</emphasis> + FOREIGN KEY (tenant_id, user_id) REFERENCES users ON DELETE SET NULL <emphasis>(user_id)</emphasis> ); </programlisting> Without the specification of the column, the foreign key would also set
В списке pgsql-hackers по дате отправления: