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.
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 |