BUG #8402: Bad error message by psql

From: bughunt(at)gluino(dot)name
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8402: Bad error message by psql
Date: 2013-08-27 09:30:52
Message-ID: E1VEFbw-0001Dr-KL@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8402
Logged by: David Tonhofer
Email address: bughunt(at)gluino(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message vincent 2013-08-27 13:53:38 BUG #8403: installing PostgreSQL breaks future registration of w32tm service
Previous Message borz_off 2013-08-27 09:04:03 BUG #8401: weird input accepted for intervals and geometric types