PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16265
PG Version12.1
OSLinux
Opened2020-02-19 01:17:22+00
Reported byJose Luis Tallon
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16265
Logged by:          Jose Luis Tallon
Email address:      (redacted)
PostgreSQL version: 12.1
Operating system:   Linux
Description:        

When dealing with schemas containing non-all-lowercase names, psql error
messages can be confusing.

Reproducer below:
-------------------
test=> CREATE TABLE "Schedule";
CREATE TABLE
test=> \dt "Schedule" 
          List of relations
 Schema |   Name   | Type  |  Owner   
--------+----------+-------+----------
 public | Schedule | table | jltallon
(1 row)
test=> \d+ Schedule
Did not find any relation named "Schedule".
-------------------

EXPECTED:
-------------------
test=> \d+ Schedule
Did not find any relation named "schedule".
-------------------

Please note that the only difference lies in case-folding of the unquoted
relation name: psql copies the relation name verbatim to the output message,
whereas it should case-fold it according to standard Postgres rules.

Messages

DateAuthorSubject
2020-02-19 01:17:22+00PG Bug reporting formBUG #16265: psql shows (unfolded) relation name in quotes
2020-02-19 15:44:49+00Tom LaneRe: BUG #16265: psql shows (unfolded) relation name in quotes