Re: Confusing error message.

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Confusing error message.
Date: 2013-04-25 03:55:53
Message-ID: CAL_0b1vC8YUmYb3Ep9fsTM4WOocMU17yoYGsMZOwSOVHR5pnGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 24, 2013 at 4:21 AM, Dmitriy Igrishin <dmitigr(at)gmail(dot)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(at)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(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Darren Duncan 2013-04-25 04:17:14 Re: custom session variables?
Previous Message Sergey Konoplev 2013-04-25 03:47:37 Re: CLUSTER, REINDEX and VACUUM on batch ops