Confusing error message.

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Confusing error message.
Дата
Msg-id CAAfz9KOErheF6gkSSY7aYxPzjSKReucRP0Q+Tp_atYPh=cqEcA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Confusing error message.
Список 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.

В списке pgsql-general по дате отправления: