Thread: Confusing error message.
Hey,
--
// Dmitriy.
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.
On Wed, Apr 24, 2013 at 4:21 AM, Dmitriy Igrishin <dmitigr@gmail.com> wrote:
> 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?
+1
[local]:5432 grayhemp@grayhemp=# table "бла.бла";
ERROR: relation "бла.бла" does not exist
LINE 1: table "бла.бла";
^
It looks ambiguous indeed.
--
Kind regards,
Sergey Konoplev
Database and Software Consultant
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com