Clarification needed

2021-06-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/libpq-pgpass.html Description: Web page https://www.postgresql.org/docs/13/libpq-pgpass.html Are the fields in the .pgpass file case sensitive by default? Obviously the password is, & it

Cities name column name inconsistent

2021-06-12 Thread PG Doc comments form
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 sam

TIMEZONE names

2021-06-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-datetime.html Description: The documentation states that some timezone names are recognized. As far as I understand others aren't. This seems to be true: $psql postgres -c "set

Re: TIMEZONE names

2021-06-12 Thread Tom Lane
PG Doc comments form writes: > The documentation states that some timezone names are recognized. As far as > I understand others aren't. There is more detail about that at https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES Note in particular that time zone abbrev

Re: Clarification needed

2021-06-12 Thread Tom Lane
PG Doc comments form writes: > Are the fields in the .pgpass file case sensitive by default? Yes. User name and database name clearly must preserve case distinctions. Maybe there is an argument for the host name to be matched case-insensitively, but I think it could cause problems when the host

Re: Cities name column name inconsistent

2021-06-12 Thread David G. Johnston
On Sat, Jun 12, 2021, 12:28 PG Doc comments form 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 thi

Re: TIMEZONE names

2021-06-12 Thread David G. Johnston
On Sat, Jun 12, 2021, 12:28 PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/datatype-datetime.html > Description: > > The documentation states that some timezone names are recognized. As far > as > I u

Re: Clarification needed

2021-06-12 Thread Dean Gibson (DB Administrator)
On 2021-06-12 12:47, Tom Lane wrote: PG Doc comments form writes: Are the fields in the .pgpass file case sensitive by default? Yes. User name and database name clearly must preserve case distinctions. Maybe there is an argument for the host name to be matched case-insensitively, but I think