BUG #8402: Bad error message by psql - Mailing list pgsql-bugs

From bughunt@gluino.name
Subject BUG #8402: Bad error message by psql
Date
Msg-id E1VEFbw-0001Dr-KL@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8402
Logged by:          David Tonhofer
Email address:      bughunt@gluino.name
PostgreSQL version: 9.2.4
Operating system:   Linux
Description:

Got a table named


"Communes_du_Luxembourg_en_Polygones"


=> \d+ Communes_du_Luxembourg_en_Polygones


Did not find any relation named "Communes_du_Luxembourg_en_Polygones"


That message is wrong!


The name of the table is not quoted, so psql is looking for


"communes_du_Luxembourg_en_polygones"


So it should say:


Did not find any relation named "communes_du_luxembourg_en_polygones"
(quoting may be needed to avoid casefolding)


And indeed:


\d+ "Communes_du_Luxembourg_en_Polygones"


works like a charm.

pgsql-bugs by date:

Previous
From: vincent@searidgetech.com
Date:
Subject: BUG #8403: installing PostgreSQL breaks future registration of w32tm service
Next
From: ajayaksadvance@gmail.com
Date:
Subject: BUG #8400: DB size changed after restore