Subject: Re: Cities name column name inconsistent
To: Bruce Momjian <bruce@momjian.us>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Jakubowski <tom@crystae.net>,
 Pg Docs <pgsql-docs@lists.postgresql.org>
References: <162345756191.14472.9754568432103008703@wrigleys.postgresql.org>
 <CAKFQuwY2-u68DGu3xJOZfiTTHTBqsx-KZ=Yn3ArOZV2_bq=CHQ@mail.gmail.com>
 <20210614162909.GA18585@momjian.us>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Message-ID: <30cc267d-8799-1ea7-a628-7e4fa6967f26@enterprisedb.com>
Date: Thu, 24 Jun 2021 13:24:01 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0)
 Gecko/20100101 Thunderbird/78.10.2
MIME-Version: 1.0
In-Reply-To: <20210614162909.GA18585@momjian.us>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/30cc267d-8799-1ea7-a628-7e4fa6967f26%40enterprisedb.com>
Precedence: bulk

On 14.06.21 18:29, Bruce Momjian wrote:
> On Sat, Jun 12, 2021 at 12:48:25PM -0700, David G. Johnston wrote:
>>
>> On Sat, Jun 12, 2021, 12:28 PG Doc comments form <noreply@postgresql.org>
>> wrote:
>>
>>      The following documentation comment has been logged on the website:
>>
>>      Page: https://www.postgresql.org/docs/13/tutorial-fk.html
>>      Description:
>>
>>      In earlier sections of the tutorial, the cities table had a column called
>>      'name'. In this chapter, when creating the revised schema with foreign
>>      keys,
>>      the same column in the cities is now called 'city'.
>>
>>
>> You are correct.  I don't see an urgent need to spend time figuring out
>> something different.
> 
> I wrote the attached patch to improve this case.

The tutorial documentation is meant to be consistent with src/tutorial/, 
which uses cities.name, so calling the column "city" was just plain 
wrong in that respect.