Re: Doing better at HINTing an appropriate column within errorMissingColumn()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Дата
Msg-id 13236.1403040974@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Doing better at HINTing an appropriate column within errorMissingColumn()  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Doing better at HINTing an appropriate column within errorMissingColumn()  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> (2) If there are multiple columns with the same levenschtien distance,
> which one do you suggest?  The current code picks a random one, which
> I'm OK with.  The other option would be to list all of the columns.

I objected to that upthread.  I don't think that picking a random one is
sane at all.  Listing them all might be OK (I notice that that seems to be
what both bash and git do).

Another issue is whether to print only those having exactly the minimum
observed Levenshtein distance, or to print everything less than some
cutoff.  The former approach seems to me to be placing a great deal of
faith in something that's only a heuristic.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: WAL replay bugs