Confusing error message.

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Confusing error message.
Date: 2013-04-24 11:21:13
Message-ID: CAAfz9KOErheF6gkSSY7aYxPzjSKReucRP0Q+Tp_atYPh=cqEcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey,

It seems to me, that this is confusing:

dmitigr=> create schema test;
CREATE SCHEMA
dmitigr=> create table test.test();
CREATE TABLE
dmitigr=> table "test.test";
ERROR: relation "test.test" does not exist
LINE 1: table "test.test";
^
dmitigr=> table test.test1;
ERROR: relation "test.test1" does not exist
LINE 1: table test.test1;

Shouldn't be first error looks like:

ERROR: relation ""test.test"" does not exist
LINE 1: table "test.test";
^
(with quoted relation name *as specified in the query*)

I've spend some time to find a bug in the application,
which performed query with entire quoted schema-qualified
relation name (i.e. "schema.relation" instead of "schema"."relation"
or just schema.relation), and the error handler printed to the log an
error message a confusing message.

Thoughts?

--
// Dmitriy.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message S H 2013-04-24 11:57:46 Re: Regarding template1 database
Previous Message Bill Moran 2013-04-24 11:14:01 Re: run COPY as user other than postgres