Re: postgres_fdw hint messages - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: postgres_fdw hint messages
Date
Msg-id 20220901223128.GA932597@nathanxps13
Whole thread Raw
In response to Re: postgres_fdw hint messages  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: postgres_fdw hint messages
List pgsql-hackers
On Fri, Aug 26, 2022 at 12:35:38PM -0400, Tom Lane wrote:
> Peter also mentioned the possibility of "did you mean" with a closest
> match offered.  That seems like a reasonable idea if someone
> is motivated to create the code, which I'm not.
> 
> I vote for just dropping all these hints for now, while leaving the
> door open for anyone who wants to write closest-match-offering code.

Here is a quickly-hacked-together proof-of-concept for using Levenshtein
distances to determine which option to include in the hint.  Would
something like this suffice?  If so, I will work on polishing it up a bit.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Allow logical replication to copy tables in binary format
Next
From: Junwang Zhao
Date:
Subject: Re: [PATCH v1] fix potential memory leak in untransformRelOptions