Re: BUG #14500: error message displays "schema dot relation" in double quotes all together

From: Vladimir Svedov <vodevsh(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Kevin Grittner <kgrittn(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14500: error message displays "schema dot relation" in double quotes all together
Date: 2017-01-17 15:38:19
Message-ID: CADqDLE8bAM+vPwjQ2u6GVf0-QYbEuWj8c-QZE4a5_2-fQHnd1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Only because when I get the error, I look closely the error message, not to
the code I just entered.
In fact I noticed error message and LINE 1 have different quoting only when
you told me.

Thank again for your time

2017-01-17 15:33 GMT+00:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:

> On Tue, Jan 17, 2017 at 8:24 AM, Kevin Grittner <kgrittn(at)gmail(dot)com> wrote:
>
>> On Tue, Jan 17, 2017 at 5:09 AM, <vodevsh(at)gmail(dot)com> wrote:
>>
>> > I'm not sure if it's a bug or feature, but I find error message
>> misleading.
>> > ERROR: relation [“schema_name.table_name”] does not exist gives an
>> > impression that schema name is part of relation name. Should not it be
>> > ERROR: relation [“schema name”].["table_name"] does not exist instead? I
>> > doubt it's a bug, because this message seems version not specific. But
>> does
>> > not it look wrong?
>>
>> I doubt that it can really be considered a bug, since it is
>> functioning as designed.
>>
>> On the other hand, it's annoying for copy/paste, especially with camel
>> case names.
>>
>>
> ​While I don't disagree for the examples I've seen​ you would just copy
> from the LINE 1 of context...
>
> David J.
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Vladimir Svedov 2017-01-17 15:40:14 Re: BUG #14500: error message displays "schema dot relation" in double quotes all together
Previous Message Tom Lane 2017-01-17 15:35:24 Re: BUG #14500: error message displays "schema dot relation" in double quotes all together