public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Magnus Hagander <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: David Gauthier <[email protected]>
Cc: [email protected]
Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
Date: Fri, 03 May 2024 17:28:20 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CABUevEyf0skbu3scVQ28_d69CCr8Bp+tU3x1AazsFwWhFJ8x8Q@mail.gmail.com>
References: <CAEs=6DnMQCAF_c+=Vup8qnOM1OT1GfFq6nzGF2a3EhgnyrjpMg@mail.gmail.com>
	<CABUevEwkSS_FhL0Zi1_m3oU5WqELHF+qQfCLDK3e__qTsYdsYw@mail.gmail.com>
	<[email protected]>
	<CABUevEyf0skbu3scVQ28_d69CCr8Bp+tU3x1AazsFwWhFJ8x8Q@mail.gmail.com>

Magnus Hagander <[email protected]> writes:
> On Fri, May 3, 2024 at 11:08 PM Adrian Klaver <[email protected]>
> wrote:
>> This:
>> "Did not find any relation named "public.some_idIds"."
>> to me indicates it did look for the properly cased name.

> That is arguably a really bad error message, because it puts those quotes
> there whether needed or not. if you put the quotes in there, you get:
> Did not find any relation named "public."some_idIds"".

This is one of the places where it's unfortunate that our English-text
rule for quoting a string to set it off from the rest of the error
message collides with SQL's rule for quoting an identifier.  Leaving
out the outer quotes would be contrary to our style guide, but having
them there can be confusing too to people who know SQL well.

It'd be better if we could show the transformed search string, but
since it's been marked up to be a regex I fear that'd introduce
even more confusion than it solves.

			regards, tom lane

view thread (17+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: \dt shows table but \d <table> says the table doesn't exist ?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox